Viewing 15 posts - 436 through 450 (of 1,790 total)
CirquedeSQLeil (12/21/2010)
David Benoit (12/21/2010)
If the default trace is enabled (default is on) then you can use the script HERE [/url]to read through that and find out possibly.
That is an excellent...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 10:05 am
If the default trace is enabled (default is on) then you can use the script HERE [/url]to read through that and find out possibly.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 9:57 am
Once you have replication configured and your initial snapshot delivered there is no reason that you should HAVE to reinitialize again. Granted it may be necessary as a best option...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 8:35 am
So, there is very little you can do to alleviate that aside from making sure that your IO subsystem can handle that activity; which at present it is not.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 8:01 am
Ok - thanks for the update. Please let me know what you see with those two counters.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 7:50 am
Yes, I see what you did. What I need to know though is Checkpoint pages/sec high when CPU is high and is there always a direct correlation. The wait type...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 7:44 am
What do you see if you set up perfmon to collect CPU information and SQLServer:Buffer Manager Checkpoint pages/sec?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 7:19 am
Brian - Have you reviewed this - http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx
Your write measures seem high but based on what you stated your read measure looks ok. What is your primary type of activity...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 6:53 am
http://technet.microsoft.com/en-us/library/ms187946.aspx - This procedure, sp_scriptpublicationcustomprocs, will create the procedures for you. A couple of notes here, first set your text output in SSMS to largest possible, second this is run...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 21, 2010 at 6:45 am
That is a recommended practice and the large transaction log backup post index rebuilds should be expected. I will say though that you will still see some log bloat even...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 3:49 pm
Ok - sorry about that. You should definitely look at getting the latest service packs in place then to solve that issue.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 3:06 pm
Pei Zhu-415513 (12/20/2010)
I wonder if...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 2:58 pm
Pei Zhu-415513 (12/20/2010)
I used structured dynamic codes something like 'use dbname; alter index .. rebuild online'...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 2:37 pm
Have you read this? Sounds like skipping commands during index operations might be an issue. I stumbled across this when looking for (vainly I might add) a document that shows...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 2:11 pm
As I stated those are NOT replicated commands. Here is an article[/url] that walks you through testing this.
Enjoy.
Edited: Previous wording sounded bad. 🙁
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 20, 2010 at 1:57 pm
Viewing 15 posts - 436 through 450 (of 1,790 total)