Parallel access to files

Hello:

Perhaps a very simple question regarding how to access the DB files in a multiprocessor machine.  

Is it possible one file to be open/accessed by more than one processor at a time?

Even modified?

Some link to documentation will be welcome.

Thanks,

Juarrero
juarreroDBAAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DavidMorrisonConnect With a Mentor Commented:
Hi Juarrero,

So a sql server database file can only be accessed by a single sql server service at a time, however sql server is multi core aware and where appropriate will use parallel processing which splits the load of a requested query across multiple cores

http://msdn.microsoft.com/en-us/library/ms178065.aspx

Thanks

Dave
0
 
Aaron ShiloChief Database ArchitectCommented:
0
 
juarreroDBAAuthor Commented:
Hello:

DavidMorrison's answer seems to be the proper response.

Thanks,

Juarrero
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.