Solved

Parallel access to files

Posted on 2011-09-12
3
220 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 250 total points
Comment Utility
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
Comment Utility
0
 

Author Closing Comment

by:juarrero
Comment Utility
Hello:

DavidMorrison's answer seems to be the proper response.

Thanks,

Juarrero
0

Featured Post

How to Backup Ubuntu to Amazon S3

CloudBerry Backup offers automatic cloud backup and restoration for Linux. It has both GUI and command line interface (CLI) ensuring its flexibility in use. Find out more

Join & Write a Comment

Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now