Viewing 15 posts - 10,096 through 10,110 (of 19,560 total)
That is good info to have too. Thanks Anthony.
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
May 18, 2011 at 8:46 am
You forgot to mention that a common problem with SQL connectivity is to ensure that the services are running.
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
May 18, 2011 at 8:44 am
wta306 (5/17/2011)
GilaMonster (5/8/2011)
Try the book MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance
I've got about 2 years under my belt with SSIS,...
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
May 17, 2011 at 1:12 pm
Welsh Corgi (5/15/2011)
GilaMonster (5/15/2011)
Goggle is a wonderful tool...quote]
Just wondering but what did I do to deserve to be called a "Goat"?
It's definition #3 in this case.
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
May 17, 2011 at 1:03 pm
No problem - glad you got it working.
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
May 17, 2011 at 12:46 pm
Good luck
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
May 17, 2011 at 12:45 pm
I think it is a combination of the two types. I don't know about calling it hard and long. When I was young a supervisor taught me 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
May 17, 2011 at 12:32 pm
what is the error message? You'll need to get that from the event logs for the host computer.
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
May 17, 2011 at 12:24 pm
bcsims 90437 (5/17/2011)
SQLRNNR (5/17/2011)
Brandie Tarvin (5/17/2011)
SQLRNNR (5/17/2011)
Ray K (5/17/2011)
bcsims 90437 (5/17/2011)
Daniel Bowlin (5/17/2011)
SQLRNNR (5/17/2011)
crookj (5/17/2011)
SQLRNNR (5/17/2011)
stickShift
clutch
hitter
pinch
Hmmm, should I spend $60 to take me and my dog to the Dodgers game...
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
May 17, 2011 at 12:07 pm
msdtc is at the root of the issue. Optimize the schema and queries. But if msdtc loses connectivity from the app to the database during execution you have...
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
May 17, 2011 at 12:05 pm
This appears to be an orphaned distributed transaction SPID. Do you have MSDTC running transactions from an application to this database?
Check this resource on how to kill that spid.
http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx
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
May 17, 2011 at 11:32 am
Create a role and grant select on those tables and view to that role. Then add that user to the role.
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
May 17, 2011 at 11:26 am
Brandie Tarvin (5/17/2011)
SQLRNNR (5/17/2011)
Ray K (5/17/2011)
bcsims 90437 (5/17/2011)
Daniel Bowlin (5/17/2011)
SQLRNNR (5/17/2011)
crookj (5/17/2011)
SQLRNNR (5/17/2011)
stickShift
clutch
hitter
pinch
Hmmm, should I spend $60 to take me and my dog to the Dodgers game on Bark in...
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
May 17, 2011 at 11:24 am
Are you trying to connect to SQL Server from the same machine?
Is the SQL Service running?
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
May 17, 2011 at 11:23 am
Ray K (5/17/2011)
bcsims 90437 (5/17/2011)
Daniel Bowlin (5/17/2011)
SQLRNNR (5/17/2011)
crookj (5/17/2011)
SQLRNNR (5/17/2011)
stickShift
Joe
clutch
hitter
pinch
Hmmm, should I spend $60 to take me and my dog to the Dodgers game on Bark in the Park day?...
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
May 17, 2011 at 11:15 am
Viewing 15 posts - 10,096 through 10,110 (of 19,560 total)