If you have any concern for disaster recovery, you'll also want to keep in mind that cross-database transactions are not supported in Database Mirroring or Availability Groups...

https://msdn.microsoft.com/en-us/ms366279

How much memory is available on the server?

What have you set sql max memory to?

Have you maxed out the memory slots in the machine?

No... not on 32-bit... But as of SQL 2005 Standard SP3 CUP4 for 64-bit you can...

http://support.microsoft.com/kb/970279

http://support.microsoft.com/kb/970070/

First off, if you're not already on the horn with Microsoft, you should file a case with them ASAP. Meanwhile, it might help if you explain what the trigger...

To me, those metrics would indicate memory pressure. How big is your database? What do your Target Server Memory and Total Server Memory look like? Also, is...

Have you tried using the Surface Area Configuration Manager to enable the DAC?

SSAC --> Surface Area Configuration for Features --> Database Engine --> DAC Enable remote DAC

Hi there,

I have a very similar configuration and also have "high" values (ranging 400 - 1200) for User Connections in my production environment.

Brad McGee discusses this counter in...