Viewing 15 posts - 5,971 through 5,985 (of 19,560 total)
I like to see questions like this cycled through from time to time.:w00t:
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
July 12, 2012 at 11:38 am
capn.hector (7/12/2012)
rhythmk (7/11/2012)
SQLRNNR (7/11/2012)
Cliff Jones (7/11/2012)
crookj (7/11/2012)
Possinator (7/11/2012)
SQLRNNR (7/11/2012)
jasona.work (7/11/2012)
EL Jerry (7/11/2012)
SQLRNNR (7/11/2012)
exploding grapesExploding Gremlins
"El" Jerry.
Mogwai
Gizmo
Bright light!
Poltergeist
They're heeeeere!
steak and maggots
Careful
Security
Burden
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
July 12, 2012 at 11:15 am
Something that has worked very well for me in this case is to run two tlog backups back to back. That will often times clear that transaction.
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
July 11, 2012 at 5:45 pm
Very good. Thanks for posting an update with an answer to your own question. 😉
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
July 11, 2012 at 5:28 pm
I like the article and the concepts you have laid out for us.
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
July 11, 2012 at 5:27 pm
Tara-1044200 (7/11/2012)
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
July 11, 2012 at 5:05 pm
Michael Lysons (7/11/2012)
It's even evident on this site. Just look at a whole...
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
July 11, 2012 at 4:51 pm
Jack Corbett (7/10/2012)
The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events...
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
July 11, 2012 at 4:44 pm
Query sys.database_principals in each database for that user.
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
July 11, 2012 at 2:49 pm
Cliff Jones (7/11/2012)
crookj (7/11/2012)
Possinator (7/11/2012)
SQLRNNR (7/11/2012)
jasona.work (7/11/2012)
EL Jerry (7/11/2012)
SQLRNNR (7/11/2012)
exploding grapesExploding Gremlins
"El" Jerry.
Mogwai
Gizmo
Bright light!
Poltergeist
They're heeeeere!
steak and maggots
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
July 11, 2012 at 2:48 pm
GilaMonster (7/11/2012)
SQLRNNR (7/11/2012)
GilaMonster (7/11/2012)
Some students clearly don't have enough work...Speaking of which, do you want some of my work and deadlines?
I said some students, not referring to self.
Lots of deadlines...
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
July 11, 2012 at 2:26 pm
It's possible that AV is running against the C as well and not the E.
I would check antivirus exclusions and settings.
As for the "backup crawler" - monitor task manager for...
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
July 11, 2012 at 2:13 pm
GilaMonster (7/11/2012)
Some students clearly don't have enough work...
Speaking of which, do you want some of my work and deadlines?
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
July 11, 2012 at 2:10 pm
I think it is an expected behavior from this undocumented procedure.
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
July 11, 2012 at 1:54 pm
Lynn Pettis (7/11/2012)
mtillman-921105 (7/11/2012)
Excuse the double post, it seemed to have gotten stuck there for a minute. :blush:
That's okay, but the links don't seem to work where I am. ...
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
July 11, 2012 at 1:53 pm
Viewing 15 posts - 5,971 through 5,985 (of 19,560 total)