Memory pressure issues

Question

Memory pressure issues

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

azgoddess SSC Journeyman Points: 90 More actions · Answer 1

Thanks for the update - we have load tested the critical update to SP2 in our test cluster and have had no problems. I have scheduled for the Friday's systems time this installation of this SP2 update and have change the startup parms to include -g512.

dataczar SSC Enthusiast Points: 182 More actions · Answer 2

I would be interested in hearing the resolution to your issue, as we just started seeing similar issues last week and are lost on what to do.

Isabelle2378 SSCertifiable Points: 6174 More actions · Answer 3

Hi,

We still have not applied the SP2 on our production server and have not seen any more memory pressure errors since we put the -g512 switch parameter in our startup. We wanted to run our server for a full month without any reboots to be sure the problem is solved and it looks like it took care of it. I have scheduled to apply the SP2 to our production server next week.

Isabelle

Thanks!
Bea Isabelle

azgoddess SSC Journeyman Points: 90 More actions · Answer 4

Exactly what fixed our problem - the -g512 switch. We had our machines at SP2 level while we were having this problem.

dataczar SSC Enthusiast Points: 182 More actions · Answer 5

What needs to be in the path with the -g512 switch?

I currently have:

-dC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\mastlog.ldf

azgoddess SSC Journeyman Points: 90 More actions · Answer 6

-dC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\mastlog.ldf;-g512