Viewing 10 posts - 256 through 265 (of 265 total)
Narine M - Tuesday, January 24, 2017 12:07 AMThen how about plan cache?
The plan cache is the same as the procedure cache.
January 24, 2017 at 6:13 am
You need to speak to your manager to get a test environment pretty urgently.
Back to your problem take it a step at a time, have you changed your...
January 24, 2017 at 4:52 am
Don't get hung up on memory pressure, have you changed you max server memory setting yet? If you are seeing scans being used in your execution plans the this points...
January 24, 2017 at 3:40 am
January 24, 2017 at 3:10 am
In Management Studio right click on your instance and then go into the memory settings. I'd set your Max Server Memory to be around 48gb initially but keep an eye...
January 24, 2017 at 3:02 am
What have you set your Max Server Memory to? SQL Server will always grab all of the memory it can.
January 24, 2017 at 2:53 am
You still won't need to restart SQL Server if you make the change through the GUI. If you are unsure what happens when you make changes using the GUI always...
November 4, 2016 at 8:13 am
No, you will just need to run the reconfigure statement.
November 3, 2016 at 8:03 am
Viewing 10 posts - 256 through 265 (of 265 total)