Learning SQL Server, SharePoint, Business Intelligence…
– Learn More or Register: Virtual Workshop: SQL Server Performance (Mar 12!)– key concepts, learning and how-to information for working with SQL Server
– Register: Spring 2010 SSWUG.ORG Virtual Conference (Apr 7, 8, 9) – SQL Server, Business Intelligence, SharePoint – 75 sessions, 20 speakers…
– Register: DBA School – (60% sold-out already) 15 ppl max – (Apr 19, 20, 21) – In-Person class that focuses on the things you really need to know – and shows/teaches how to apply it.
Time’s running out to register for each of these – please register soon to save your spot.
Interesting Tuning Best Practice
I was digging around the Microsoft site, looking through guides, tips and such looking for a nugget for today and stumbled across a surprise, at least to me.
Did you know that how you set up your data files can impact how information is stored on your various drives? You might think you’re spreading the information stored across different drives by setting up different data files on different drives… you’re right, to a point.
The tip, though, is that you make the different data files the same size. What?! Really? Yep. SQL Server uses an algorithm as it stores information to your data files, looking for the largest available chunk of free space at the time, then using that space to store the next chunk of information. Very intriguing to know! What this means is that if you set up a big data file for your database as one of the storage locations, you could actually find that SQL Server *only* uses that data file for storage for a while. At the very least, it may heavily favor it in storing information to your drives. If you want to optimize things, well, optimally, review those data files and see if you can set them up in similar sizes.
While we’re talking about this – you do know about a couple of other tips – right?
– pre-allocate the space you need, don’t use autogrow.
– don’t use auto-shrink.