The default alignment of 31.5Kb on Windows Server 2003 can lead to enormous I/O performance problems with SQL Server (see Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly?). I thought it would be useful to do a quick blog post showing how to use the diskpart and wmic tools.
SAN Performance Tuning with SQLIO The SQLIO Disk Subsystem Benchmark Tool was a free utility from Microsoft that measures storage I/O performance and has been retired and replaced by DiskSpd.exe. You can download the tool and documentation here. FYI: The rest of this article relates to the deprecated utility sqlio.exe. Contents 1 SQLIO Video Tutorial 2 Downloading and Configuring SQLIO 3 Testing Your SAN Performance 4 Importing SQLIO Results into SQL Server 4.1 Script to Create the Tables and and ETL Stored Procedure 4.2 Importing the Text File into SQL Server 2005 5 Analyzing the SQLIO Results 6 More Reading About SQLIO
So you’ve configured log shipping. That’s only half of the puzzle solved. This article will show you how to reverse SQL Server log shipping roles of the primary and standby server, then reverse them again without the need of a full backup (if your primary server is still accessible). This method is very handy when you’re dealing with large databases.
If you’ve changed your Operating System hostname, you should reflect that change in SQL Server by updating the name in the Master database. SQL Server doesn’t support updating the name when involved in database mirroring, replication, or clustered environments. You’ll have to remove the feature, update the name, then re-add the feature.
Query to find the fragmentation status of all indexes on a single database. Line 11 you need to insert your db name.