IT Placement Papers  Database SQL Server
This category contains SQL Server Interview Questions and Answers |
How can you get SQL Server 2005 to simulate multiple processors for query testing?
|
|
|
|
|
Use the -P parameter in the startup parameter list.
Explanation: You can use the -Px trace flag in the startup parameters, where x is the number of processors to simulate. Beware of using numbers higher than 4 on a single processor machine. Also note that this is unsupported by Microsoft.
Only registered users can write comments.
Please login or register.
|
