Unable to access SQL Server

Question

Unable to access SQL Server

Viewing 4 posts - 16 through 18 (of 18 total)

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

Abu Dina SSChampion Points: 14155 More actions · Answer 1

My only concern is that by stopping/starting the SQL Server service, I may have stopped something from working. I'm looking at the SQL Server logs but I'm not sure how to track the offending process.

Any tips?

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 2

I'm sure you stopped some process that was running - which is a good thing. 🙂

I would recommend doing some logging via a system level trace or logging of sp_whoisactive to collect expensive queries and start tracking those back to see if they can be tuned. Some information for logging from sp_whoisactive can be found HERE[/url].

You probably won't find anything in the log so it is a good idea to get some logging in place prior to the next event so that you will be able to speak to the issue and hopefully come up with a resolution before it happens.

Enjoy.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Abu Dina SSChampion Points: 14155 More actions · Answer 3

Thanks David.

I actually installed sp_whoisactive as soon as the SQL instance was back online 😀

Thanks for the links about the logging. That's exactly what I'm looking for.

If and when I catch the naughty process I will report back with my findings.

Once again, thanks for your time.