Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PBM ExecuteSQL Query & Min Memory Settings Expand / Collapse
Author
Message
Posted Saturday, May 04, 2013 12:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439
Hi all,

Im trying to use PBM a bit, but came into a few problems.

Problem 1:

Setting up a Min Memory setting policy, trying to find any servers that haven't been configured

Server Configurations @MinServerMemory > 0

But using this on a server with no configured min mem it returns 16???

Using

SELECT [value]
FROM sys.configurations
WHERE [name] = 'min server memory (MB)'

I return 0.

Any ideas why?

Problem 2:

I tried to use ExecuteSQL to run the above code (mainly to try and learn using executeSQL) I get the error:

'Property ExpressionNode is not set'

The Cell is:

ExecuteSql('Numeric', 'SELECT [value]
FROM sys.configurations
WHERE [name] = 'min server memory (MB)'')

Hope someone can help.


Post #1449452
Posted Saturday, May 04, 2013 2:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 9:41 AM
Points: 118, Visits: 439
Second one solved! It needed double ' around the min server memory (MB) like below.

ExecuteSql('Numeric', 'SELECT [value]
FROM sys.configurations
WHERE [name] = ''min server memory (MB)''')
Post #1449466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse