Viewing 15 posts - 1 through 15 (of 16 total)
enabled trace flag 8780 as identified execution plan time out in the profiler collected.
some of the quries going good but other become worse and in error log shows
"A time out...
November 25, 2011 at 12:53 am
parameter sniffing is also ruled out and trying to force use the good(fast) execution plan..
please give me the inputs if am missing something:-)
November 23, 2011 at 10:13 pm
other observation is that Version store is used to be huge around 300GB in old environment which is around a few 10's of GB in the new environment.
the Execution plan...
November 23, 2011 at 8:21 am
Error messages:
The process could not execute 'sp_replcmds' on 'SE-81\VIKSQLR2'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
Could not obtain information about Windows NT group/user 'SE\Vtantry', error code 0x54b. (Source:...
October 24, 2011 at 8:45 am
I'm not sure what your question is here. Are you wondering why test_user can't SELECT from test_table? It's because test_user is a member of public, and you haven't REVOKEd the...
June 26, 2011 at 10:54 pm
vinsat (10/28/2010)
but facing errors/issues and not able to configure the same.Can anybody help me how to debug this issue?
How to fix this kind of problems in replication.
Regards,
wat is...
October 29, 2010 at 5:58 am
In my case the current DR strategy is pretty basic where we have a full backup evry single day followed by a Diff evry 'x' Hrs and log for evry...
October 27, 2010 at 2:49 am
Roy Ernest (10/22/2010)
It is best to not to set "Sync with Backup" option set if you want minimum latency.
The Latency will come in to focus only if i set...
October 27, 2010 at 1:45 am
So, Finally I can't set my Distribution database recovery to SIMPLE as I set the SYNCWITHBACKUP "true" on distribution database. the publisher log will not be truncated untill log is...
October 22, 2010 at 1:45 am
Roy Ernest (10/5/2010)
The distributor can be set up in Simple mode. I do not see why you will want to keep it in Full mode.
If you...
October 12, 2010 at 12:25 am
winash (10/6/2010)
What is your current DR strategy?
As Gail already mentioned - the decision on full v/s simple is not related to performance. Check http://msdn.microsoft.com/en-us/library/ms152560(v=SQL.90).aspx for details on backing...
October 8, 2010 at 4:05 am
thanks for edifying me and guiding me on how to approach.....
October 6, 2010 at 7:33 am
thanks for your suggestion, and clarifying me things around performance and recovey model.
the thing is that the distribution log is growing and i am taking Tx-log backups(in case for point...
October 6, 2010 at 5:43 am
Reg. performance as per my knowledge simple recovery will be better than full in case like BCP. and in my environment the disrtibution log file is growing huge auto growing...
October 6, 2010 at 4:54 am
yup the Replication doesn't depend on the Recovery model,but
my query is that
1) how much perfomance gain i can get using simple recovery for distributor database.
2)how the DR stratagy should be...
October 6, 2010 at 1:45 am
Viewing 15 posts - 1 through 15 (of 16 total)