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

Advertisements

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

%d bloggers like this: