Viewing 15 posts - 17,281 through 17,295 (of 19,560 total)
Chad Crawford (2/16/2010)
RBarryYoung (2/16/2010)
(if that doesn't make sense, then note closely the dates & times in 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
February 16, 2010 at 1:31 pm
I second Lynn's motion.
Please provide more information. Error messages are critical pieces of information to share.
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
February 16, 2010 at 1:28 pm
RBarryYoung (2/16/2010)
(if that doesn't make sense, then note closely the dates & times in the thread above, and...
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
February 16, 2010 at 1:19 pm
I was recently convinced to go ahead and re-certify. I was looking to use the same materials as Tommy for this particular exam.
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
February 16, 2010 at 1:14 pm
Anything else running on the server besides SQL?
Are the statistics up to date on the server?
Are the indexes in a reasonable state of defragmentation?
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
February 16, 2010 at 1:09 pm
Lynn Pettis (2/16/2010)
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
February 16, 2010 at 1:07 pm
Elliott W (2/16/2010)
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
February 16, 2010 at 12:04 pm
Elliott W (2/16/2010)
CirquedeSQLeil (2/16/2010)
Come to think of it - it seems like he just wanted us to hold his hand and do it for him maybe 😀
That link you sent...
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
February 16, 2010 at 11:51 am
I currently run 75% of my databases on SQL 2000 (I know, big ouch). I use one instance of SSIS 2008 to perform various tasks against all of my...
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
February 16, 2010 at 11:44 am
Only requirement is that SSIS be installed. If it is installed, it will be able to perform this for SQL 2000.
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
February 16, 2010 at 11:41 am
Please enable logging from within the maintenance plan. It will give more detail about the cause of the failure than the SQL Agent log.
Here is a link that shows...
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
February 16, 2010 at 11:36 am
Interesting article with a nice flow.
Thanks
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
February 16, 2010 at 11:12 am
Come to think of it - it seems like he just wanted us to hold his hand and do it for him maybe 😀
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
February 16, 2010 at 11:09 am
Elliott W (2/16/2010)
Do people not know how to read these days..
Between me and another prominent poster we provided an answer and a link to exactly do the answer. And...
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
February 16, 2010 at 11:08 am
You're welcome.
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
February 16, 2010 at 11:06 am
Viewing 15 posts - 17,281 through 17,295 (of 19,560 total)