How to stop sql server 2008 services

Question

How to stop sql server 2008 services

srilu_bannu

Hall of Fame

Points: 3100
More actions
July 19, 2010 at 8:54 am

#226967

Hi everyone,
I have Sql server 2005 on my computer and recently i have installed sql server 2008 client tools.
Now i am working on a package which will import data from excel into sql server 2005 database which is taking much longer time to even open the package .and gave me this error while working on the tasks:
exception type system.outofmemoryexception was thrown
So , i have decided to stop all the sql 2008 services and work on 2005 ,but i was unable to find sql server 2008 in
AdministrativeTools->Services .i can only see sql server services which doesn't say anything about 2005 or 2008.
Can anyone please tell me how to stop sql server 2008 services?

Viewing 8 posts - 1 through 7 (of 7 total)

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

Mike01 SSChampion Points: 11395 More actions · Answer 1

you only installed the sql server 2008 client tools, so there is no service to stop. If you installed the database,then you would have had to use a named instance and the services would show up with the names instance attached to it.

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 2

Hi

If you installed the SQL Server 2008 client tools, there is no SQL Server 2008 service installed. Otherwise look at Start->Programs->SQL Server 2008->Configuration Tools->SQL Server Configuration Manager. If any services are installed, you can stop them in this tool.

Greets

Flo

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 3

Thank you.

Then what exactly is causing the delay to even create a package in BIDS 2005 ,i am seeing all the delayed notifications from Microsoft(like Microsoft is busy and waiting to complete an internal operation...) and exception errors(exception type system.outofmemoryexception was thrown).

even after the completion of my package (which is taking half day for simple package),the performance of the package is worst....

my teamlead has installed sql server and i have installed only client tools.does that effect memory on my computer?

will accept any suggestions...

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 4

I don't think, the memory issues depends on the installation of SQL Server 2008 client components. Have a look into task manager (or system monitor) while executing your package to figure out which application takes all the memory.

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 5

searchfilterhost.exe (local service) is taking around 300,000 to 500,000 k memory .and devenv.exe which is BIDS is taking 26,000k when i am not making changes to BIDS ,but when i change anything in BIDS it is going up to 400,000k...

no matter how many times i end the process searchfilterhost.exe,it is coming back.

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 6

AFAIK searchfilterhost.exe is part of Windows Search and Indexing service. Try to stop the windows service.

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 7

I got an error trying to stop the windows service so i disabled it.

But when i make any change in BIDS package especially Source which is from an excel it is taking more memory .(devenv.exe is going up to 800,000 k)