March 30, 2011 at 3:17 pm
The answers to your questions are not straight forward. It depends on your DB, usage, and environment.
I'd recommend reading this blog by Paul Randal on the topic.
The best answer would be to do a lot of testing and find the best configuration for your setup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 30, 2011 at 3:51 pm
Thanks for the link, that is what I was looking for (I can't believe I missed that, I was just on thier site yesterday). And that is the answer I was afraid of as well, without the time and hardware to test more, I'm just stabbing in the dark.
One thing Paul doesn't mention in his post though is the possibility of corruption. I would imagine the larger the file sizes the higher the possibility of file corruption at the OS level?
March 30, 2011 at 3:56 pm
Tough to say on that one. If you figure that a larger file will cover more sectors than a smaller file - then the possibility of corruption from a disk sector going bad could be increased. But I haven't seen anything that would substantiate that hypothesis.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply