Hello,

I support an application where all resources are mirrored across two data
centers. We have a situation where our clustered SQL servers in data center
1 allocate and use memory differently. For example, both servers in the SQL
2-node cluster in data center 1 will allocate approx 24Gb of the 32Gb
installed to SQL. In data center 2, only 1 server will allocate 24Gb. The
other server will only give approx. 6Gb to SQL. This leads to obvious
performance problems and we cannot figure out why.

Therefore, I've been asked to write a script that will pull the
configuration of SQL Server on each physical server. We need to find &
identify where the differences in the configurations lie.

My problem is, I don't know what to look for in SQL Server. Can anyone help
me to understand what SQL configuration parameters I should be attempting to
get?

All the physical SQL servers are verified identical.

Thanks in advance,
Rich

Hmmm. You don't know what to look for. But I don't know what you are looking
for. I'm not a VB programmier, but I'll give you a starting point.
First, figure out what instances of SQL Server are on the computer. WMI is
probably going to help with that. Though not quite what you asked for, here
is a PowerShell script that shows how to get the WMI info
http://msdn.microsoft.com/en-us/library/dd206997.aspx
Then you can connect to SQL Server, and using Transact-SQL sp_configure
might return all the info you need.
I hope this helps.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"rich" <rich (AT) discussions (DOT) microsoft.com> wrote