SSWUG Free Expo Event: Real-World SharePoint Administration – Tomorrow
Friday, February 11, 2011, 9 a.m. – 1 p.m. PST
Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG for one month. After the expo, the content will be available for further review and study.
Register today to reserve your place!
DBTechCon – Spring 2011
The SSWUG Spring 2011 virtual conference is quickly coming together. You can go to the registration page and see profiles for presenters, and summaries for the sessions to be presented. Without a doubt, this will be the largest virtual conference in the information technology industry. Access more than 70 sessions from well seasoned professionals with in-depth instruction on technologies such as SQL Server, SharePoint, .Net, Business Intelligence and much more. Register any time from now to April 19th. There are early registration discounts for those who register early. Go to the Registration page for more details and to get signed up right away.
$$SWYNK$$
Featured White Paper(s)
VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER
In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more)
Featured Script
check_table_index_frag.SQL
Some people still have SQL 6.5 in their environments… SQL 6.5 doesn’t allow you to use SHOWCONTIG with the table name, so y… (read more)
SQL Server Management Studio Standard Reports
It’s amazing what you can find out about your database right from the SSMS console. Microsoft has packaged a number of useful reports allowing you to quickly view statistics about the SQL Service and Databases it hosts.
While not a complete replacement of the management views added since SQL Server 2005, these reports compliment the views providing a nice interface for quick execution and often graphical representation of the data.
There are two levels of reports you can access from the object explorer in SSMS. If you right click on a SQL Instance icon a context menu appears from which you may choose Reports->Standard Reports->Your Desired Specific Report.
| Report | Description |
| Server Dashboard | providing statistics about the various cache utilizations, etc.) |
| All Blocking Transactions | Shows all blocking transactions across all databases hosted by the server |
| Top Queries by Average CPU Time | Shows list of top 10 queries with the highest average CPU time |
| Top Queries by Average IO | Shows list of top 10 queries with the highest average Disk IO |
There are a lot more server level reports that may better fit your situation.
If you right click on a database icon in the object explorer of SSMS you may also select database specific reports.
| Report | Description |
| Disk Usage | Shows pie chart of how disk space is used for data and transaction log. Also provides File specific disk usage in grid |
| Disk Usage by Top Tables | If you want to know what tables are using up disk space, this report helps. |
| All Blocking Transactions | Nice if you want to determine or discount transaction blocking in your system impacting performance |
| Object Execution Statistics | Nice for finding queries that would benefit from optimization |
| Index Usage Statistics | Nice to determine if your indexes are helpful for your queries |
One thing to be aware of is that these statistics are cleared out each time you restart the SQL Service.
Currently you can’t select any of the text in the reports to paste elsewhere. However, the reports can be exported to Excel where you can copy text.
Do you have any other tips you’d like to share for our DBA’s that will help them perform their role easier. Send your tips to btaylor@sswug.org and I’ll be sure to post them.
Cheers,
Ben