Viewing 15 posts - 17,221 through 17,235 (of 19,560 total)
After the MaxDOP suggestion, try barking up Lowell's suggestion to output to file.
Both are good suggestions.
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 17, 2010 at 10:47 am
Another alternative is to determine if 500MB every 30 minutes is legitimate transactions.
I ran across a scenario where nearly 1TB was created a day in transactions due to some methods...
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 17, 2010 at 10:36 am
GilaMonster (2/17/2010)
Roy Ernest (2/17/2010)
Does each User group get a free pass or something? I hope so... 🙂
Each PASS chapter gets, for the chapter leader. You have to be an affiliated...
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 17, 2010 at 10:31 am
I wonder if jcrawf02 had anything to do with the missing thread? He was the last to post there :Whistling:
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 17, 2010 at 10:29 am
Hmmm. I like Jeff's idea. I also like Emmitt's idea. Is this database starting fresh? Are the triggers truly needed for this data load?
If the triggers...
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 17, 2010 at 10:27 am
Steve Jones - Editor (2/17/2010)
Not sure what happened, working on a timewarp restore now, as soon as I can get the pwd from IT
:ermm:
Wow, the thread was jealous?
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 17, 2010 at 10:25 am
Lynn Pettis (2/17/2010)
Just looked here: Anything that is NOT about SQL!Looks like the DBCC Timewarp thread is just gone. Curious, can it be recovered?
Yup - looks like 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 17, 2010 at 10:23 am
cmallain (2/17/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 17, 2010 at 10:22 am
Woot
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 17, 2010 at 9:28 am
Jeff Moden (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 17, 2010 at 9:27 am
The intent of this post was to try to get a feeler for anybody that might be in town that week. I am trying to line up some speakers...
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 17, 2010 at 9:23 am
I think somebody just DBCC timewarped me. I lost 17 post points over night. (I was counting down to 5000, thus the reason for knowing.)
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 17, 2010 at 9:20 am
TECHBABU (2/16/2010)
step 3 Look the status column for lot of repetitious number two 2 , if they are more then you go ahead and try shrinking of log file.
A very...
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 17, 2010 at 12:22 am
Thanks Paul. Excellent question. I learned quite a bit about checksums for this question (most of it coming from your blog).
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 17, 2010 at 12:18 am
When the log file needs to grow, it will block transactions from completing until the log file has adequate space. The reason it will grow is due to inadequate...
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:53 pm
Viewing 15 posts - 17,221 through 17,235 (of 19,560 total)