Ragesh Puthiyedath Raju
Reputation: 3939
How to get MS SQL SERVER Database wise CPU usage report
I am using Sql Server 2008 Standard Edition in my PC. There is more than 30 databases are
running in my Server. I am try to generate a report based on database wise CPU usage
report. Is possible this report as graphical ?
Please Help
Upvotes: 0
Views: 3035
Answers (1)
James Martin
Reputation: 907
Not sure if this is possible but I’d try looking at some of the third party monitoring tools and trying to reverse engineer how its done.
Red gate has a tool you can check out but I’m sure there are many others as well
Upvotes: 1
Related Questions
- SQL Server report Performance - Top Queries by Total CPU Time - what's included
- Actual CPU usage per database
- How can you get database specific performance metrics for things like CPU/Memory/etc. in SQL Server 2005?
- CPU utilization by database?
- SQL: How can I get the number of executed queries per database or hour or ...?
- SQL Server : statistic of each database, How much each db is used
- Detecting SQL Server Utilization with a query
- How do you gather statistics from SQL Server?
- How to Get SQL Server Database performance Information?
- SQL commands to get performance statistics