Viewing 15 posts - 3,961 through 3,975 (of 19,560 total)
Hany Helmy (1/22/2014)
Forgot it, so I had to make some RnD to get it right.
Nice approach. That's the kind of response I like to see.
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 22, 2014 at 7:25 am
Culprit
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 21, 2014 at 2:04 pm
GilaMonster (1/21/2014)
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 21, 2014 at 9:53 am
GilaMonster (1/21/2014)
SQLRNNR (1/21/2014)
GilaMonster (1/21/2014)
praneethydba (1/21/2014)
Still in Recovery. I am Panic.
Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on 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 21, 2014 at 8:41 am
GilaMonster (1/21/2014)
praneethydba (1/21/2014)
Still in Recovery. I am Panic.Be patient.
The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side
Here...
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 21, 2014 at 8:31 am
Nice article Rodney.
I have built redundant alerts in the past and had gotten away from it. But, it makes a lot of sense. Especially considering the high frequency...
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 20, 2014 at 9:22 am
Gary Varga (1/20/2014)
Jim P. (1/18/2014)
...The other part of it is to know when you have too many that it gets ignored...
This is key. The same is true with the communications...
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 20, 2014 at 9:20 am
Thanks Steve.
I agree with the notion to blog. Besides the improvement in writing skills and the practice at doing it, it has also helped me to become a better...
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 20, 2014 at 9:13 am
Gary Varga (1/16/2014)
Also, step forward and you will find others will step forward with you who wouldn't have done so alone.
Amazing how that works.
Great advice Chris. Sometimes the most...
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 20, 2014 at 9:08 am
While waiting for it to come online, have you checked the disk system? Have you checked general server health? Have you checked permissions (make sure they haven't changed)?
Your...
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 20, 2014 at 8:53 am
clyde_mcmurdy (1/20/2014)
Should I start a new one?
"... ProcedureName WITH RECOMPILE means that the procedure's plan is never cached at all"
That's...
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 20, 2014 at 8:49 am
Here's a script to help with that
http://jasonbrimhall.info/2011/11/16/table-hierarchy-goes-cs/
As the post cautions, the script slows significantly when dealing with circular references.
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 20, 2014 at 8:42 am
Nice Script Perry. When transferring logins, I will always go for the script approach similar to what Perry has shared.
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 20, 2014 at 8:35 am
Is your database back online?
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 20, 2014 at 8:33 am
Rockford
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 17, 2014 at 1:40 pm
Viewing 15 posts - 3,961 through 3,975 (of 19,560 total)