SQL Server 2008 > how to get service startup parameter values by query?

Posted by Sean Ochoa on Stack Overflow See other posts from Stack Overflow or by Sean Ochoa
Published on 2010-05-07T17:59:32Z Indexed on 2010/05/07 18:18 UTC
Read the original article Hit count: 165

Is it possible to query for the SQL Server 2008 service startup parameter values using T-SQL? I'm specifically looking for the -g parameter that indicates how much memory that SQL Server will leave available for memory allocations within the SQL Server process, but outside the SQL Server memory pool [msdn reference].

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about sql-server