memory usage sqlservr.exe in SBS2008
|
From: Marc on 22 Jun 2010 04:57 Hello, I have installed a new SBS2008 standard server, no clients connected yet. I did MS updates on the server and all went fine. now i check the server and found out that sqlservr.exe is ussing 5.154.776kB This is very large and I want to adjust the max of usage. is this possible and how to? in command line or in studio manager? i tried this http://www.smallbizserver.net/Articles/tabid/266/Id/327/categoryId/62/How-to-set-memory-usage-of-the-Internal-Database-on-a-SBS-2008.aspx but i get: user does not have permission... regards Marc
From: Larry Struckmeyer[SBS-MVP] on 22 Jun 2010 06:20 Hi Marc: In the enhanced security model of 2008 and Windows 7, you should try right click and "run as administrator" if you have such a message. -Please post the resolution to your issue so others may benefit. -Get Your SBS Health Check at www.sbsbpa.com
From: Brian Cryer on 22 Jun 2010 06:37 "Marc" <marcharms(a)invalid.com> wrote in message news:OpekqjeELHA.588(a)TK2MSFTNGP06.phx.gbl... > Hello, > I have installed a new SBS2008 standard server, no clients connected yet. > I did MS updates on the server and all went fine. > now i check the server and found out that sqlservr.exe is ussing > 5.154.776kB > This is very large and I want to adjust the max of usage. > is this possible and how to? > in command line or in studio manager? > i tried this > http://www.smallbizserver.net/Articles/tabid/266/Id/327/categoryId/62/How-to-set-memory-usage-of-the-Internal-Database-on-a-SBS-2008.aspx > but i get: user does not have permission... > regards Marc Try it using the built in Administrator account. -- Brian Cryer http://www.cryer.co.uk/brian
From: Marc on 22 Jun 2010 10:39 Could you describe how? I enabled the administrator in Acive dir users and computers, but i get the same error. Marc > "Marc" <marcharms(a)invalid.com> wrote in message > news:OpekqjeELHA.588(a)TK2MSFTNGP06.phx.gbl... >> Hello, >> I have installed a new SBS2008 standard server, no clients connected yet. >> I did MS updates on the server and all went fine. >> now i check the server and found out that sqlservr.exe is ussing >> 5.154.776kB >> This is very large and I want to adjust the max of usage. >> is this possible and how to? >> in command line or in studio manager? >> i tried this >> http://www.smallbizserver.net/Articles/tabid/266/Id/327/categoryId/62/How-to-set-memory-usage-of-the-Internal-Database-on-a-SBS-2008.aspx >> but i get: user does not have permission... >> regards Marc > > Try it using the built in Administrator account.
From: Brian Cryer on 23 Jun 2010 05:05
"Marc" <marcharms(a)invalid.com> wrote in message news:OJNkwihELHA.5500(a)TK2MSFTNGP05.phx.gbl... > Could you describe how? I enabled the administrator in Acive dir users and > computers, but i get the same error. Have you logged in using the administrator account and then tried? This isn't the same as running-as-administrator. -- Brian Cryer http://www.cryer.co.uk/brian |