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.