What’s the first thing you do when you get a report of a problem on one of your servers? In my case… i run this following script that gives me a quick overview of all the top counters of interest. Continue reading “Sql Server Status”
Backup Script to replace xp_sqlmaint
Need a backup script because xp_sqlMaint is not running on 2008? Try this one. You need only fill in the database name and directory name in the appropriate places below: Continue reading “Backup Script to replace xp_sqlmaint”
Out of disk space…Log file grown too big?
It’s early in the morning, and you’ve got disk space problems… log file, right? Yep. OK, we need a script that will tell us what we need to know ASAP. Since i experienced this issue multiple times…and since they always happened on Sunday morning…just before i was going to church (how much more inconvenient can it get?)…i created just such a script. Using two CTE’s i first gather the information i need about the database data files, and then the database log files. Since there can be multiple physical files for either type, i max and sum the needed values before grouping. Then, i combine that data with sys.database information. The result gives me almost all i need to know in a single picture…i’m ready then, with a simple “xp_fixeddrives” to get straight to fixing things. Continue reading “Out of disk space…Log file grown too big?”