If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.
High memory usage sqlservr.exe, sqlservr.exe *32
I've got a Microsoft Small Business Server 2008 and the SQL Server 2005 with the default SBSMONITORING instance consumes a lot of memory. I've got two sql services:
sqlserv.exe takes about 389Mb;
sqlserv.exe*32 takes about 259Mb.
For the default sbs monitoring i think this is alot of memory!? Is ther a way to decrease the memory size?
sqlserv.exe takes about 389Mb;
sqlserv.exe*32 takes about 259Mb.
For the default sbs monitoring i think this is alot of memory!? Is ther a way to decrease the memory size?
Asked:
1 Solution
Yes those memory values seem normal...although I know myself it's a pain how much memory it takes up.
If you've got a dedicated SQL server I'd take one of the sql servers off (SHAREPOINT).
As @olafdc suggested you can limit the memory usage of the instance by logging in via SQL Management studio and disabling AWE, then tapping in the desired memory limit.
If you've got a dedicated SQL server I'd take one of the sql servers off (SHAREPOINT).
As @olafdc suggested you can limit the memory usage of the instance by logging in via SQL Management studio and disabling AWE, then tapping in the desired memory limit.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
If you want to tweak them down just use the sql server Management studio express console, open the the sql instance you want to tweak, right click on it, open Memory and set upper value.
Foe MSSQL instance open: \\.\pipe\mssql$microsoft##
You can reenabkle the administrator account in Active Directory Users and Computers.
Hope that helps,
Olaf