July 20, 2011 at 7:06 am
MudLuck (7/19/2011)
I have also read the article and it makes since that at the OS level only one thread can look a file at a time.
There for if you have multiple CPU'S that can run multiple threads simultaneously that you create an I/O bottle neck if you only have one MDF file. I was however interested in the Log file.
Does SQL Server Use parallelism in the checkpoint command. In other words would I benefit from adding one or two more logs to the tempdb?
My inclination is no but couldn't find anything one way of the other what do you all think?
My inclination is that it is inappropriate to post to 4 year old threads. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 20, 2011 at 8:57 am
TheSQLGuru (7/20/2011)
MudLuck (7/19/2011)
I have also read the article and it makes since that at the OS level only one thread can look a file at a time.
There for if you have multiple CPU'S that can run multiple threads simultaneously that you create an I/O bottle neck if you only have one MDF file. I was however interested in the Log file.
Does SQL Server Use parallelism in the checkpoint command. In other words would I benefit from adding one or two more logs to the tempdb?
My inclination is no but couldn't find anything one way of the other what do you all think?
My inclination is that it is inappropriate to post to 4 year old threads. 🙂
People find us through google all the time. I never stop myself at that assuming I have solid info to post.
Viewing 2 posts - 46 through 46 (of 46 total)
You must be logged in to reply to this topic. Login to reply