[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Parallel access to files

Posted on 2011-09-12
3
Medium Priority
?
243 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:juarrero
3 Comments
 
LVL 5

Accepted Solution

by:
DavidMorrison earned 1000 total points
ID: 36521803
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
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 36521813
0
 

Author Closing Comment

by:juarrero
ID: 36711954
Hello:

DavidMorrison's answer seems to be the proper response.

Thanks,

Juarrero
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question