I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory Manager/Total Server Memory). I would like to allocate nearly all ...
All: Short of breaking out the cluster administator tool (GUI), given a serversnetbios or DNS name, how can I deduce the SQL server names (and instances) that may be present on that server. Ideally, I could pass