Browse by Tags

All Tags » IO (RSS)
Wednesday, March 19, 2008 8:17 PM

How many files should my database have?

A question I get asked quite a lot is "how many files / filegroups should my database have?". As we all know there is only one right answer to all of life's questions and that is: "it depends!". Lucky for us the guys from the SQLCAT team have taken the time to explain a little how to evaluate how many files you need for specific...
Posted by WesleyB | with no comments
Filed under: ,
Tuesday, October 02, 2007 9:04 PM

Some I/O improvements in Windows Server 2008

Windows Server 2008 offers a lot of new features that are very visible like Internet Information Server 7.0, a whole new virtualization model, Server Manager and many many more. But being a SQL Server person I am interested in other things that have been improved. These not so visible features are mostly I/O related since databases...
Posted by WesleyB | 1 comment(s)
Filed under: ,
Tuesday, March 13, 2007 8:24 PM

I/O counters in Task Manager

One of my freaky habits is to check the I/O counters in the task manager. Whenever I'm doing I/O intensive stuff I like to quickly look at the MBs processed. Whether these counters are updated or not is controlled by a registry setting (see below). You can set the value to 0 to disable it or 1 to enable it. Disabling it gives a little...
Posted by WesleyB | with no comments
Filed under:
Friday, October 27, 2006 8:18 PM

Why "lock pages in memory" may increase I/O performance

I was reading SQL Server I/O Basics, Chapter 2 when I came across a very interesting chapter discussing the "Lock Pages In Memory" policy. You all know that the AWE API is used to lock pages in memory and this is true for 32-bit as well as 64-bit SQL Server installations. Do note that the "awe enabled" configuration settings exists...
Posted by WesleyB | with no comments
Filed under: ,
Tuesday, September 26, 2006 11:45 AM

SQL Server vs I/O

Out of all the hardware requirements for SQL Server the I/O requirement is one of the most common bottlenecks since it is usually the most difficult to manage and extend. Before you consider installing SQL Server on a production environment make sure you understand the I/O requirements for SQL Server and test your hardware accordingly...
Posted by WesleyB | with no comments
Filed under: ,