The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Insights From Your Database Using PowerShell and TSQL

Hello All.

I have been looking for quite some time for ways to understand my databases better. There are a lot of DMVs and even some DMFs that help us get information from the SQL Server engine that can be very insightful. Many shops use monitoring tools and they are great because they watch things all the time. I used to rely solely on these tools to get me information about my SQL Server environment. That has shifted since I have been managing a SaaS platform built on top of SQL Server. With hundreds of TB of data and many databases being the same, it becomes pretty daunting to know which databases to care about and how much to care.

This article is about what you can do to get ready for a better maintenance strategy or understanding how your indexes are used.

Read more 1 Comments

RSS

Theme picker

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids