Multiple filegroups: yay or nay?comes from: http://sqlserverpedia.com/blog/category/database-design/Monday, September 29th, 2008Stephanie wrote in wit......
Plus, when I started managing storage area networks, I had a different reason. Storage is getting faster and faster every year, but DBAs aren’t getting any more hours in their day. Keeping data and indexes on different filegroups requires careful attention during development. All it takes is one knucklehead adding an index without paying attention, and bam, you’ve got indexes on the data filegroup. That means you have to introduce a new task into your daily/weekly/monthly routine: running a query to identify which objects are on which filegroups.
What a pain.
I’ve struggled with finding and hiring good DBAs, and if I have a choice between making my database 5% faster or making my DBAs 5% faster, I choose that latter option. I can get 5% more storage performance by adding a few more drive spindles, but it’s harder - and more expensive - to get 5% more good DBA time.
On the other hand, if I was in a shop where my DBAs had plenty of time (or worked for peanuts, whate, then I would take a sandbox system, set it up the same way as production, and do performance benchmarking to see how much of a difference a separate index filegroup made on my exact hardware, storage and application.
You’re asking me, though, so I bet you don’t have the time to do that research either. In that case, keep it simple!
2/2 首页 上一页 1 2 |
