You’re getting ready to buy more drives, but what should you use them for? If you’re a developer designing a database schema or a production DBA configuring storage, maybe you’ve thought about putting indexes on a separate filegroup.
I’ll explain when it’s right to add more files, the difference between filegroups and files, and why you probably shouldn’t separate out indexes into their own filegroup — but what should go into those new filegroups? You’ll learn in this 33 minute video:
Liked that video? Here’s some of our past videos that you can watch immediately:
Adi December 7, 2011 | 11:33 am
Great tutorial!
So, once you apply the multiple filegroups/files infrastructure, it is sometimes a bit difficult to easily understand what’s sitting where.
And so, I’ve created this free tool called “Database File Explorer” which may really help in these cases. (I know the name is not catchy, but it kinda says what it does
)
You can get it from my website – http://www.doccolabs.com/products.html
Hope it helps
Jeffry December 7, 2011 | 3:40 pm
Great video
I was not on the website but i just saw it and i learnt a too much information, thanks brent for do presentation like this
you rock for all of us who are in this database world.
John Sansom December 8, 2011 | 8:12 am
Another brilliant presentation Brent, jam packed full of knowledge and effortlessly explained.
There’s an awful lot of good advice here condensed into a small 30 minute sound-bite and I imagine that some folks probably don’t realise just how big the performance payback can be from adopting the recommendations. Like you, I had to learn a lot of this the hard way.
Folks if you get the opportunity I highly recommend that you attend some training delivered by Brent.
Speaking of which, do you have any plans to speak/visit us folks in UK next year?
Brent Ozar December 8, 2011 | 9:38 am
Thanks, sir! I appreciate the compliments!
I would love to hit SQLbits soon, but the next SQLbits is the exact same week as SQL Connections here in the US. I’m doing a pre-con at Connections, so I gotta stay here. Maybe next time! I love SQLbits and can’t wait to get back over there.
Pingback: Something for the Weekend – SQL Server Links 09/12/11
Anup December 9, 2011 | 6:12 pm
Excellent and very neat webcast Brent! Really loved the way you present these stuff.
Btw MDF seems to be Master Data File for me
Cheers!
Anup