Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mssqlnewbie
Starting Member
3 Posts |
 Posted - 2012-03-21 : 09:39:00
|
Hi,Reducing the Production Server Tuning Loadhttp://technet.microsoft.com/en-us/library/ms190389.aspx which leads tofrom 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