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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-21 : 08:46:52
|
| Nathan writes "What is the best tool (MS or third party) for determining which databases are using the most resources, specifically CPU and Memory? There seem to be lots of ways of looking at specific SQL statements or stored procedures but I can't find anything that will produce a simple graph with CPU on the left and individual Databases on the bottom.Thanks,Nathan NesjeMerrill Corporation" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-21 : 08:54:22
|
| ??? Performance Monitor. You can't track it to individual databases though. Processes take up memory and CPU, not databases. You need to combine Perfmon with Profiler to get a good picture.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Tool for SQL resource monitoring by database