Tag Info

New answers tagged


The correct syntax is using plus as a delimiter. xperf -start MySession -on 2DA81B52-908E-7DB6-EF81-76856BB47C4F+A9377239-477A-DD22-6E21-75912A95FD08+BA798F36-2325-EC5B-ECF8-76958A2AF9B5


Log into SQL Server Management Studio, Right-click your instance and go to Properties > Memory. By Default, SQL Server 2012 Standard sets your Maximum Server memory to something ridiculous like 2147483647 MB. I would set the Maximum server memory for SQL Server to be something like 8192 MB (or less than 32GB). Instead of using PerfMon, perhaps you can ...

Top 50 recent answers are included