We all know that autogrowth events are bad, for a lot of reasons. For starters, it increases the number of VLOGs for the transaction log. Second, depending on your settings, it may also slow down your server if these are often enough. Third, it means that you, as a DBA, missed something in the configuration … Continue reading Reporting on AutoGrowth Events
Month: May 2015
The joy of FILEGROUP_NAME (and probably other as well)
Part of my scripts collection, is a script that returns the details of a table: storage, metadata (sys.objects), partitioning, etc. I was using this script for quite a while and ran ok. Few days ago, however, after I disabled an index on a partitioned table it failed and the error was a bit puzzling: Msg … Continue reading The joy of FILEGROUP_NAME (and probably other as well)
Aggregation and partitioned tables
One of my main tasks is to keep a close eye on performance. Every time we have a major release, I have to start looking at performance, find main culprits and fix them. Well, not me, but work with developers and find a solution to the issues at hand. And our databases are rather large, … Continue reading Aggregation and partitioned tables
SQL-PLAY 