Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server service is not stopping Expand / Collapse
Author
Message
Posted Tuesday, January 8, 2013 12:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 27, 2014 11:13 PM
Points: 95, Visits: 387
There was a bottleneck in a server.
In order to avoid that I have changed some configuration changes in the Server for Memory setting, Processor settings (Unchecked Automatically set processor affinity, Automatically set IO affinity) and connection settings.

When the services were restarted it went to a hung state.
The service is not starting or stopping.
The instance cannot be accessed.

The state in SQL Server Configuration Manager is "Change pending..."
Can you please help?

Thanks in advance.
Post #1403994
Posted Tuesday, January 8, 2013 1:50 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:50 AM
Points: 517, Visits: 346
Try reading the errorlog - still accessible either by opening the errorlog file directly (it's a plain text file) or via the "Applications" tab in the windows event log. More often than not, this will provide useful information about what's going on.



Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1404051
Posted Tuesday, January 8, 2013 2:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 27, 2014 11:13 PM
Points: 95, Visits: 387
I have restrarted the server and the services has started now.
I connected to the instance.
But when I am trying to open Properties of the instance I am getting the following error:

Failed to retrieve data for this request
Failed to connect to server
A connection was successfully established with the server,
but then an error occured during login process.
(Provider: Shared Memory Provider error: 0-No process is on the other end of the pipe)



I have confirmed that all the protocols are enabled.
Post #1404062
Posted Tuesday, January 8, 2013 2:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 27, 2014 11:13 PM
Points: 95, Visits: 387
I stopped the browser serice and connected to the server.
Then I started the browser service.

It worked for me.

Thanks for your help
Post #1404079
Posted Monday, December 1, 2014 10:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:49 AM
Points: 3, Visits: 10
I changed the browser services to manual from disabled.
and started the services it work for me .

Megha
Post #1640551
Posted Monday, December 1, 2014 10:54 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
Knowledge Hunter (1/8/2013)
There was a bottleneck in a server.


What kind of bottleneck?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1640553
Posted Monday, December 1, 2014 11:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:49 AM
Points: 3, Visits: 10
There was no bottleneck. Issue was related to "CHANGE PENDING STATE" of all services showing on SQL server configuration manager page , though my application was running absolutely fine.



Post #1640560
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse