Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Displays statistics for automatic multiprogramming level adjustments in the database server message log.
dbsrv12 -gns ...
Statistics are not displayed
All operating systems except Windows Mobile.
Network database server only.
Multiprogramming level statistics are recorded in the database server message log only when the -gns option is specified.
You can change the setting for the reporting of multiprogramming level statistics once the database server has started using
the sa_server_option system procedure.
If you want to know whether multiprogramming level statistics are currently being reported, execute the following query:
SELECT PROPERTY ( 'AutoMultiProgrammingLevelStatistics' );