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

%d bloggers like this: