Solved

Parallel access to files

Posted on 2011-09-12
3
223 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
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DELL iDRAC 6 35
Simple SQL query from two tables 13 54
Query Syntax 17 34
SQL2016 to ORACLE11G linked-server 6 13
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

773 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