Viewing 15 posts - 16,576 through 16,590 (of 19,560 total)
GTR (3/11/2010)
Are you doing this from local machine or remote client? what is the result when you run this query?select name, status, status2 from sys.sysdatabases
The instance is currrently not available....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 2:51 pm
Off to the desert I go (or should it be dessert 😉 ). Lynn is the tent available?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 2:49 pm
And the agent service is unable to start, correct?
Do you have some error messages in the Security event log, failure events that correlate to when you try to start the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:54 pm
Please verify that you have SQL Browser service running.
Verify that the account for Sharepoint Instance of SQL Agent is a valid account with valid password (not expired, etc).
Verify that The...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:41 pm
AndrewSQLDBA (3/11/2010)
Why are you running Exchange and SQL on the same box? Do you have a backup of the Sharepoint database and the sharepoint server?Andrew SQLDBA
Just speculating, but since...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:21 pm
It seems that your Sharepoint instance services are not running. Has a password expired or changed for the sharepoint account used to run the services?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:20 pm
Steve Jones - Editor (3/11/2010)
Did you mean option 1? I tend to agree with you, though I might run a rollup each day looking for an overall look of what...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:57 pm
tosscrosby-60625 (3/11/2010)
Lynn Pettis (3/11/2010)
CirquedeSQLeil (3/11/2010)
Lynn Pettis (3/11/2010)
[font="Comic Sans MS"]Party!! (At Jeff's)[/font]:w00t:
How many are invited?
Don't know, how big is Jeff's house? 😛
Don't forget the tent (additional sleeping/partying quarters) and the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:40 pm
tosscrosby-60625 (3/11/2010)
CirquedeSQLeil (3/11/2010)[
😀
I just shaved mine off.
Kind of hard to tell from the avatar......
Look closer - but don't get too close to the horn 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:37 pm
crookj (3/11/2010)
Pork Chops being served? :w00t:Joe
Via trebuchet...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:32 pm
Are you able to launch SQL Server Management studio and connect to each of the instances you listed?
To find server version, run the following from SSMS
select @@version
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:32 pm
I can just imagine some sort of "Animal House" party happening. No matter the size, I'm sure we could fit a few hundred thousand 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:27 pm
GilaMonster (3/11/2010)
Luke L (3/11/2010)
I wonder how long it be 'til he catches Steve?
Interesting.
Difference in post count between Steve and Jeff and between Jeff and I is almost identical. I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:25 pm
Roy Ernest (3/11/2010)
I can see myself at the age 90+ trying to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:21 pm
Lynn Pettis (3/11/2010)
[font="Comic Sans MS"]Party!! (At Jeff's)[/font]
:w00t:
How many are invited?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:16 pm
Viewing 15 posts - 16,576 through 16,590 (of 19,560 total)