Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database Slowness

Author  Topic 

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2009-12-31 : 13:38:16
Hi,

Few customers are complaining DB slowness. Does anyone have any script which will point where is problem? Does anyone know which freeware tool can help me find such kind of issue?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-31 : 14:50:08
You can use SQL Profiler to determine what is going on.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

learntsql

524 Posts

Posted - 2010-01-02 : 02:46:20
Hi Tara,
Will SQL Profiler slow down the server performance?
My server would be busy in the morning hours Can i directly run SQL Profiler in production server to capture things or any other way.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-01-02 : 06:48:10
It will slow down the performance , try and run the Profiler from another server, and filter only specific events.
As a starter , you could try :
a)capture sql statements that are long running (you need to define what is slow)
b)look for scans (index and table)

Also , what sort of maintenance are you running , for example are the statistics up to date?

Jack Vamvas
--------------------
http://www.ITjobfeed.com (IT jobs)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-02 : 13:00:16
Here's how to run SQL Profiler and not impact other things: http://weblogs.sqlteam.com/tarad/archive/2008/08/06/SQL-Profiler-best-practices.aspx

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -