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 |
|
learntsql
524 Posts |
 Posted - 2009-12-21 : 05:01:17
|
| Hi..Is there any way to figureout the %of CPU and Memory utilization of each database in server.Can i trace these and store it into some file/table for my further ananysys.TIA. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ajitgadge
Starting Member
12 Posts |
Posted - 2009-12-22 : 07:25:53
|
| You can use WMI event class and alerts and store the perfmon counters information ( like CPU , Memory, I/O Utilization) in database to generate the reports. |
 |
|
|
|
|
|
CPU & Memory Utilization as per database