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 |
|
jaybee
Yak Posting Veteran
72 Posts |
 Posted - 2008-11-01 : 09:04:22
|
| Hi all,I'm new to my environment, and recently one of my colleagues spotted that the statistics needed to be updated on one of our databases - so I obliged. I was shocked that they NEEDED to be updated - I had assumed a hardware issue as, everywhere else, I've seen this task automated at least weekly - but that's not the issue for this post, just the background.Now, my question is, how did he work out where the problem lay? I remember him using a combo of Perfmon and SP-Who2 to identify who was running the query, but for something like this, what counters and columns (respectively) would you look at in each?Thanks,JB |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-01 : 09:25:57
|
| You can see Standard reports that comes SQL Server for top CPU,Memory intensive and I/O Consuming queries. Or you can correlate Performance monitor with SQL Profiler to nail down the issue. |
 |
|
|
|
|
|
Nailing performance issues