SQL Server - Administrative Queries / Metadata Queries?
-
Thursday, March 21, 2013 10:15 PM
Hi Everyone!
I'm a relatively new SSRS Developer. In my current role I've been creating reports for every area of the company except for IT.
I would really like to surprise my boss and develop a report for him that relays statistics on how the SQL Servers are performing and running, to make managing of the servers a bit easier for him. I think these are called metadata queries, is this correct?
Can anyone point me to a collection of SQL server queries that might be helpful? Perhaps you have one of your own that you don't mind sharing? etc.
Thanks in advance,
Craig
- Edited by determinism Thursday, March 21, 2013 10:15 PM
All Replies
-
Thursday, March 21, 2013 10:22 PM
Hi
Depending on what you're looking for...you should probably start with the system DMVs for performance, query usage etc. Just remember that the DMV data is volatile, so if you are interested in maintaining that data for historical reasons/review...you should consider saving that data or creating your own PDW (perf data warehouse). Though...sql 2k8 or 2k12 comes with that.
And...you might want to check out the native/provided perf reports (built like ssrs). Right click on your database server and choose "Reports" and then follow the sub menu to the area you are interested in -> Performance, Activity, Server dashboard.
I know that there are some articles on line for this too....step by step.
- will
- Marked As Answer by determinism Monday, March 25, 2013 10:36 PM
.png)
