asked on 3/21/2017

SQLsvr.exe SBS 2011memory issues

After I applied the latest patch from M$ this week ,it appears as if SQLsvr.exe is grabbing a bunch of memory.
No program is using SQL except maybe the built in Sharepoint app.
Any ideas?
sql.PNG

SQL SBS

Last Comment

pgm554

3/21/2017

ASKER CERTIFIED SOLUTION

Lee W, MVP

3/21/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

pgm554

3/21/2017

ASKER

I'll give it a try.

Before the patches ,it was at about 6gb used all together.

I have another SBS 2011 was at about 11gb before patches that is now at 15gb out of 16gb.

pgm554

3/21/2017

ASKER

I tried the memory limiting and set both instances to max of 100 ,the first one gave a slight improvement ,the Sharepoint instance was significant.
My memory usage went from 15 gb on my other SBS2011 ,to a little over 8 gb.
sp.PNG

SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

61K

Questions

Followers

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY