How to use the SQLIO Simulate utility Stress Test.


I’ve to bring up an SQL Instance to production, and before install all the components I decided to verify the behaviour of the server with a stress tool for IO. Choose the tool SQLIOsim to simulate this charge test. You can read How to use the SQLIOSim utility here http://support.microsoft.com/kb/231619/en-us,¬† and the tool can be downloaded using this link download.microsoft.com/download/6/5/2/65286f65-bff2-42b8-b0c9-87f117855069/sqliosimX64.exe.

After download and unzip it to an folder run the tool. Read more of this post

Using Mount Points in a Microsoft SQL Cluster Server Environment


When we use an Cluster for supporting SQL Instances in medium or bigger organizations we will have some TeraByte of data. Our Infra-Structure must be prepared to grow and in some times to grow faster without the possibility of stopping to improve or migrate, so there are some Advantages of using the NTFS volume mount points feature in a Microsoft Cluster Server Environment, such as: Read more of this post

Listing registry keys for all resources in a 2003 Cluster


This might be useful for documentation and also for migration plans related to an SQL Cluster. Read more of this post

SQL Data Migration Between LUNS – Change Cluster LUNS ID’s and Drive Letters


In this specific we could not extend the LUN so we need to migrate data from LUNS, and keep the same ID’s and Drive letters, because SQL Services does not use Drive letter’s, instead use the LUNS ID. we have a Two node Windows 2003 Cluster and Two SQL 2005 Instances. Read more of this post

%d bloggers like this: