It's a big shared environment with 9 other instances of SQL Server are running. Approximately 200 GB of physical memory remains unallocated at this time. No BI tools...

Physical - Not VM

Model : ProLiant DL580 G7

CPU : 4x10

Memory : 512 GB

OS : Windows 2008R2 ENT

Max Server Memory = 20 GB

Since...

Check to see if you have any stored procedures that use Table Valued Parameters. TVPs are implemented as CLR assemblies via Microsoft.SqlServer.Types. The application could exhaust this memory...

I resolved a similar issue while building an infrastructure script to process T-SQL batch files. I encountered many issues trying to programmatically capture the error message from sqlcmd.exe. ...

Brian >> My SQL Server service runs under a domain account with membership in the Windows Administrators group. Thought this measure would alleviate any impact to SQL Server due...

Brian,

Thanks for the quick response. I didn't mean to confuse the issue by introducing Polyserve. I just want to know dropping and recreating these groups will cause any...