|
mssqlnewbie
Starting Member
2 Posts |
 Posted - 03/21/2012 : 09:39:00
|
Hi,
Reducing the Production Server Tuning Load
http://technet.microsoft.com/en-us/library/ms190389.aspx which leads to
from http://technet.microsoft.com/en-us/library/ms189551.aspx
quote:
The extended stored procedure, xp_msver, must be enabled to use the test server/production server scenario. Database Engine Tuning Advisor uses this extended stored procedure to fetch the number of processors and the available memory of the production server to use while tuning the test server.
Where should xp_mserver be called? on the production server or test server? My hunch is that it will be the production server. right?
thanks a lot! |
|
Database Tuning Advisor Using Test Servers
