Speaking in Raleigh NC June 15th

Andrew Kelly — Wed, 02 Jun 2010 20:53:00 GMT

Just a heads up to those in the area that I will be speaking at the (TriPASS) Raleigh SQL Server user group on the 15th of June 2010. The topic is Storage & I/O Best Practices. The abstract is listed below:

SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most neglected or mis-configured areas of a SQL Server instance. Here we will focus on the best practices related to how SQL Server works with the underlying storage subsystem and what you can do to maximize the relationship between the two. The core topics will include discussions on SANs vs. Direct Attached storage, Raid Groups, Caching, Types of I/O, Number of Files & their placement and more.

http://www.tripass.org/dnn/

I am looking forward to seeing you there.

Andrew J. Kelly

Getting back to the basics with I/O

Andrew Kelly — Sun, 13 Jan 2008 15:25:13 GMT

One of the most common trends that I see related to performance & scalability with SQL Server is a poorly configured or implemented storage subsystem. There is a ton of information out there on this subject but in my opinion that is part of the problem. Too much data is not always a good thing and there is a lot of misinformation out there as well. I also see a lot of systems that were configured based on the advice someone gave them or they read about which may have been great for that other system but not necessarily for theirs.

So I think it is time we got back to the Basics and Best Practices when it comes to I/O in SQL Server. Again in my opinion and my experience from seeing systems all over the world this list should get people off on the right foot if they are not sure what they need or how they should approach a proper I/O configuration. The first article hits the nail right on the head and is a great place to start. The next two give a very good understanding of what actually goes on when SQL Server makes I/O requests and explains the terminology so that everyone can talk the same language. The 4th link is a relatively new white paper to most that should be sort of a bible and gone over long before you deploy or even buy the equipment for your next SQL Server. And finally there is a link that everyone should be aware of that gives you access to a whole host of white papers that should be read as needed.

SQL Server Storage TOP 10 Best Practices

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx

SQL Server 2000 I/O Basics

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

I/O part 2 for updates to SQl2000 SP4 and SQL2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

SQL Server I/O Pre-Deployment Best Practices

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

Overall SQL Server Best Practices

http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

Search results matching tags 'Performance', 'I/O', 'Best Paractices', and 'Storage'

Speaking in Raleigh NC June 15th

Getting back to the basics with I/O