October 8, 2011 at 3:38 pm
I am looking to generate a report per database for various resources consumed -
physical IO ,
logical IO - memory used,
CPU cycles
Looking for suggestions. Thank you
October 8, 2011 at 4:08 pm
Some of this is in DMVs.
Here's a set of queries that shows some I/O for database files, a few more as well: http://dl.dropbox.com/u/13748067/SQL%20Server%202008%20Diagnostic%20Information%20Queries%20%28September%202011%29.sql
October 11, 2011 at 9:29 am
Check out the Performance Tuning with SQL Server Dynamic Management Views book by Louis Davidson and Tim Ford. I've just finished chapter 6 which is titled - PHYSICAL DISK STATISTICS AND UTILIZATION.
Highly recomend this book especially for this issue.
Thanks
Chris
January 16, 2012 at 4:44 pm
I have been able to work out the IO details per database, thank you for your inputs.
How do I get the CPU and memory per database over a period of time? Is there any way that this can be acheived?
January 16, 2012 at 4:48 pm
Steve Jones - SSC Editor (10/8/2011)
Some of this is in DMVs.Here's a set of queries that shows some I/O for database files, a few more as well: http://dl.dropbox.com/u/13748067/SQL%20Server%202008%20Diagnostic%20Information%20Queries%20%28September%202011%29.sql
No need to go any further - just use these scripts by Glenn Berry.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2012 at 6:21 pm
Thanks for the details - the queries are extremely helpful.
I am looking to collect data at intevals, and thereby identify the high, low and average usage patterns within a specified interval of time (something like we see on perfmon blg files are replayed, but on a database level.) This needs to take into account things like server restarts(since DMVs get reset). At any point of time I would subtract the CPU/memory/io used till the last sampling timestamp to get the current usage.
I am still working out of other factors that need to be considered, I understand this is very specific, it would be great to get some ideas/inputs. Thank you 🙂
February 6, 2012 at 3:16 pm
bumping the thread - apologies if not allowed
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply