Introduction to SQL Server Reporting Services – Tomorrow, August 25
Last chance to sign up for the next virtual class, "Introduction to SQL Server Reporting Services". This "Made Simple" course, taught by Sherri McDonald, a Business intelligence expert from Pragmatic Works, is a great investment for your personal development. If you’re ready to up your game, come on in and join us next Tuesday.
Dynamic Management Views
I came across a little bit of gold this last week prompting me to touch on this subject. Dynamic Management Views (DMV) are tools unique to Microsoft SQL Server. They provide insight into the operations of an instance of SQL Server.
The views provide information regarding a number of different things. Using DMVs you can find information about the state of your data. You can determine the fragmentation of tables or indexes. You can determine the state of the statics for your tables. You can identify indexes that are not being used.
Query performance may also be evaluated through DMVs. Using DMVs you can identify queries that are not performing well, queries that would perform better with a different index, or even queries that benefit from the generation of statistics.
This is just the tip of a great big iceberg. There is so much more information at your fingertips through the portal of DMVs.
Personally, I use DMVs all the time. There are so many different DMVs I haven’t had the time to really cover them all. So here’s the gold. This last week I obtained a new book written by Ian Stirk called "SQL Server DMVs in Action".
If you need to know what is going on in your database server, I highly recommend this book. Already I have had great success resolving some I/O issues that have been plaguing me for some time.
Ian provides over 100 real examples using DMVs to view meaningful actionable information about
- indexes
- Query performance
- The operating system,
- The CLR
- Transactions
- Databases
This is a true goldmine you are going to want on your shelf.
What are the books or websites you keep close at hand? Care to share the tools you find useful with our readers? Send your favorites to btaylor@sswug.org.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
What to Do When There are No Funds to Develop a Functioning Project
When a project has little funding to draw from and database professionals have to develop a functioning product, it is important to present management with all the options. If they understand the rewards and risks, then they will attempt to make the best decision for the company.