How to get IO statistics of SQL Server database files
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
6,829 reads
DMV
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
1,750 reads
What Is Filling Up The Transaction Log
Report unusual conditions that may be filling up your transaction log.
2010-12-22
451 reads
Blogs
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Forums
Dropping a Service from Service Broker crashes server
I'm having an issue trying to drop a service. When I issue the drop...
SQL MI - SQL Jobs failing with User Manager\ContainerAdministrator.
This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...
Tempdb: is it being used?
hi so i have a really old application that is used to process data...
Ask SSC