LOG Parser – IIS Charts

In this post I will show some examples how to create some charts from information collected in IIS Logfiles. For this purpose I will use LogParser version 2.2. and Office Web Components.

You can download LogParser version 2.2 here – http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1976 and read more about it here http://technet.microsoft.com/en-us/library/bb878032.aspx

You can download Office Web Components here http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22276

Let’s begin. Read more of this post


Test Disk IO performance

To execute this process I will use Iometer tool. You read more about here, http://www.iometer.org and download here http://www.iometer.org/doc/downloads.html

To configure the application I’ve made some options, check this images. Read more of this post

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

Wmic – manage pagefile

You can mange your pagefile with the wmic commad. 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

%d bloggers like this: