Daily Links 24th June 09
Here are Kev’s links for today
Maintaining high availability of SQL virtual machine
Danielle Ruest and Nelson Ruest, Contributors
Since the release of Hyper-V, Microsoft has continued its commitment to server virtualization by releasing new software products that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.
Read More on SQL Server Search
Capturing I/O patterns using Process Monitor
By Edward Elliott,
The single most expensive native operation SQL Server can perform is reading and writing to the disk. While SSD drives have been hailed as the future and fault tolerant ram drives are prohibitively expensive, most of us still use the humble mechanical disk drive to store and retrieve data. Understanding SQL’s I/O patterns can help you design your disk infrastructure and knowing your application’s patterns can help you get the most out of your disks.
In this article I will be show how to measure the quantity and size of I/O requests in each database as well as being able to work out where your I/O’s are hitting and then matching those up with physical tables. To do this we can use the free “Process Monitor” tool and then load the output into SQL Server.
Pretty good post. I just came across your site and wanted to say
that I have really liked reading your posts. In any case
I’ll be subscribing to your blog and I hope you write again soon!