SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Troubleshooting wait stats
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 04/01/2012 :  05:45:29  Show Profile  Reply with Quote
Hi all,

We have a 3rd party tool that highlights 'Session times in seconds" (I presume this means wait stats), but doesn't yield much info as to who is running those sessions and for what purpose.

I know you can run SP_WHO_3 that can provide a pretty good start, but that must first be installed as a stored procedure, for which we'd need to raise a CRF that will take an age to be approved.

Meanwhile, are there any (ad-hoc) queries I can run, or articles/resources that will give me a head start on this problem?

Thanks,

Jake

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 04/01/2012 :  14:23:40  Show Profile  Visit tkizer's Homepage  Reply with Quote
Anything wrong with good old master..sysprocesses and sp_who? Without more information about the 3rd party tool, it's really hard to give you any guidance.

SQL 2000? Troubleshooting there, well it ain't so easy. Hopefully you've got an upgrade plan in place.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 04/01/2012 :  15:56:16  Show Profile  Reply with Quote
Hi Tara, it's Ideera, as for upgrading SQL I agree with you, but that will be a long way off, for various reasons, so I need to work with the situation at hand.

Edit - we have about four sessions running into several thousand seconds in length.

Edited by - Jake Shelton on 04/01/2012 17:16:44
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 04/01/2012 :  17:27:15  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
First question - is that a problem? Are those 'sessions running into several thousand seconds in length' causing problems?

and I'll echo Tara's question, anything wrong with sysprocesses and sp_who?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 04/01/2012 :  17:33:41  Show Profile  Reply with Quote
quote:
Originally posted by GilaMonster

First question - is that a problem? Are those 'sessions running into several thousand seconds in length' causing problems?

No - but I want to see what they are, and take any necessary action, before they become painful


quote:
and I'll echo Tara's question, anything wrong with sysprocesses and sp_who?
--

I'll let you know when I've tried them. :)
Go to Top of Page

Jake Shelton
Yak Posting Veteran

74 Posts

Posted - 04/08/2012 :  08:38:21  Show Profile  Reply with Quote
Ironically enough, using the above two commands plus InputBuffer, the long-running processes turned out to be nothing more threatening than inserts into a DB audit table!!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000