December 10, 2008 at 2:29 am
My computer occassionally drags when I don't think it should be.
When that happens, I press CTRL-ALT-DEL and take a peek at the processes that are running. Sometimes it's Carbonite uploading, and sometimes it's McAfee downloading, but sometimes it's SqlServer, and I am not running anything that should be running SqlServer.
How is this possible? (Is it possible without something insidious driving it?). (In these cases, SqlServer is not listed as a running Application.)
--Roy
December 10, 2008 at 5:50 am
asrisl (12/10/2008)
How is this possible? (Is it possible without something insidious driving it?). (In these cases, SqlServer is not listed as a running Application.)
It won't be listed as a running application because it's not. SQL Server is a service, and as such, if set to start automatically, is always running. There will be background tasks that it does.
If its a problem, and you don't need SQL available all the time, go into the Services app and set SQL to start manually, then you can start the service as needed and not have it running all the time
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 6:03 am
Thank you. I found a switch like what you described under "Surface Area Configuration." I trust that is the one to which you were referring. It is set to Manual and is turned off.
Thanks again.
Roy
December 10, 2008 at 6:07 am
asrisl (12/10/2008)
Thank you. I found a switch like what you described under "Surface Area Configuration." I trust that is the one to which you were referring. It is set to Manual and is turned off.Thanks again.
Roy
I was referring to the ones under Administrative tools - Services, but Surface Area Config should do the same thing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2008 at 6:11 am
I don't have that in my list of programs, or in any menu that is on-screen when SQL Server is running. Maybe its because I have the Express (free) edition. But the fix I undertook does seem to have worked. -roy
December 10, 2008 at 6:25 am
asrisl (12/10/2008)
I don't have that in my list of programs, or in any menu that is on-screen when SQL Server is running.
It's not a SQL menu. Window's administrative tools. Accessed from Control Panel.
Surface area config will do the same thing. Different interface to the same thing
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply