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.
| 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 |
|
|
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. |
 |
|
|
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) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database Slowness