Viewing 15 posts - 17,896 through 17,910 (of 19,560 total)
GilaMonster (1/25/2010)
Urgent! Urgent! Urgent!http://www.sqlservercentral.com/Forums/Topic853117-145-1.aspx
Exterminate! Exterminate!
Couldn't help myself on that one. Let's see if the OP can go and figure it out now.
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
January 25, 2010 at 10:31 am
Here is a thread that may help you find your solution. You will still need to look at the code and determine how to adapt it to your situation....
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
January 25, 2010 at 10:30 am
Steve Jones - Editor (1/25/2010)
Looks like The Thread is alive and well. Good to be back and hoping everyone behaved over the last week.
Welcome back. Hope it was restful,...
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
January 25, 2010 at 10:22 am
tweet tweet
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
January 25, 2010 at 10:19 am
Good statistics will help improve query performance.
The downside is that you will need to perform maintenance on those indexes - which you should be doing anyway. If you don't...
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
January 23, 2010 at 5:49 pm
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
January 23, 2010 at 4:49 pm
You can use those scripts in production - but only do so after you have tested, tested, and tested some more.
Some of the recommendations from DTA are good. Not...
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
January 23, 2010 at 4:13 pm
It does not run in the background per se. The maint plan should be executing the same script and taxing your server just the same as if you ran...
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
January 23, 2010 at 4:09 pm
It looks like you might have a corrupted registry string.
Check the following:
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
January 23, 2010 at 4:04 pm
If the copy job is truly failing, then it shouldn't be able to restore and be in synch.
Are you copying to multiple locations by chance?
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
January 23, 2010 at 3:55 pm
Alvin Ramard (1/23/2010)
WayneS (1/23/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
January 23, 2010 at 3:15 pm
WayneS (1/23/2010)
P Jones (1/22/2010)
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do anything...
Bet that's 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
January 23, 2010 at 1:22 pm
😀
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
January 23, 2010 at 1:13 pm
D.Oc (1/23/2010)
CirquedeSQLeil (1/23/2010)
Jeff Moden (1/23/2010)
Detroit. We have Lions here, too, but they have no teeth. 😉There's a lot more than just teeth that your lions don't have 😛
Oh, now...
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
January 23, 2010 at 12:46 pm
Jeff Moden (1/23/2010)
CirquedeSQLeil (1/23/2010)
There is a poorly written runaway sql statement causing heavy tempdb usage.Concur. In fact, I've found that to be the norm rather than the exception.
In 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
January 23, 2010 at 11:39 am
Viewing 15 posts - 17,896 through 17,910 (of 19,560 total)