Viewing 15 posts - 17,476 through 17,490 (of 19,560 total)
Bob Hovious (2/8/2010)
Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font],...
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 8, 2010 at 9:25 pm
Bob Hovious (2/8/2010)
Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font],...
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 8, 2010 at 9:19 pm
Nice. More efficient. I hadn't considered this method. Makes sense though.
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 8, 2010 at 5:11 pm
Please also provide the test data that you are using to create this scenario.
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 8, 2010 at 5:06 pm
That is pretty efficient as it is. There are other methods - however, what you are using is quite adequate.
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 8, 2010 at 5:01 pm
I am unable to load your database into my environment.
Please provide create scripts and data insert scripts.
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 8, 2010 at 4:33 pm
Jeffrey Williams-493691 (2/8/2010)
When in doubt, I review the following excellent articles:http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
I must agree 😎
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 8, 2010 at 3:39 pm
jcrawf02 (2/8/2010)
Guidelines that you've all read already, or if you haven't, then you will have read by the time you finish thinking that you should read them....whatever..
Are...
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 8, 2010 at 1:09 pm
commonality
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 8, 2010 at 12:48 pm
I think Gail, Grant and Paul have made the counter points very well. It seems that the decision in this article to jump straight to emergency mode recovery was...
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 8, 2010 at 11:39 am
There are complications when setting the log file size low and then the growth to also be low. If you have a bunch of log growths, your log may...
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 8, 2010 at 11:23 am
Great Editorial. You bring up a very simple point that we try to make daily. There are measures out there that are guides. The guide is a...
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 8, 2010 at 11:11 am
Nice question. 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 8, 2010 at 11:00 am
george sibbald (2/8/2010)
CirquedeSQLeil (2/8/2010)
nigel. (2/8/2010)
george sibbald (2/8/2010)
Its possible if you have some of its poo.
Oh yeah, plenty of s*** round here :-). Gotta make sure I use the right...
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 8, 2010 at 10:34 am
nigel. (2/8/2010)
george sibbald (2/8/2010)
Its possible if you have some of its poo.
Oh yeah, plenty of s*** round here :-). Gotta make sure I use the right sample, or could...
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 8, 2010 at 9:45 am
Viewing 15 posts - 17,476 through 17,490 (of 19,560 total)