Viewing 15 posts - 8,836 through 8,850 (of 19,560 total)
GilaMonster (9/1/2011)
SQLRNNR (9/1/2011)
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
September 1, 2011 at 4:09 pm
Looks like just the tools upgraded and not the database engine.
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
September 1, 2011 at 3:01 pm
More of an issue to make sure ducks are in a row. Want to make sure a migration is planned out properly and that takes time.
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
September 1, 2011 at 3:00 pm
Jeff Moden (9/1/2011)
SQLRNNR (9/1/2011)
GSquared (9/1/2011)
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
September 1, 2011 at 2:56 pm
GSquared (9/1/2011)
SQLRNNR (9/1/2011)
GSquared (9/1/2011)
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
September 1, 2011 at 2:22 pm
GSquared (9/1/2011)
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
September 1, 2011 at 1:56 pm
varsity
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
September 1, 2011 at 1:07 am
Nice question. Better than the question is the explanation given.
Thanks Paul.
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
September 1, 2011 at 12:44 am
webtekkie alludes to another important thing.
This really is an effort that requires communication and teamwork. Net Admins and DBAs together should be working to physically inventory the SQL Instances...
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
August 31, 2011 at 12:55 pm
Those databases if not maintained can pose a risk and threat to your entire environment.
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
August 31, 2011 at 12:32 pm
I agree with Roy. Based on the info, I'd start by removing the cursor.
It also appears that you are using temp tables for staging the data. Are these...
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
August 31, 2011 at 11:32 am
toejam
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
August 31, 2011 at 10:25 am
Read the first article in my sig. Gail walks you through how to post that info.
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
August 31, 2011 at 10:19 am
On second thought - there is the procedure cache.
Try this:
http://sqlserverpedia.com/wiki/Queries_in_Procedure_Cache
Keep in mind, that this is not a fool proof method to retrieve past queries.
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
August 31, 2011 at 1:17 am
Without some form of logging that you setup (like triggers or traces) - no.
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
August 31, 2011 at 1:15 am
Viewing 15 posts - 8,836 through 8,850 (of 19,560 total)