Viewing 15 posts - 16 through 30 (of 99 total)
I found all those rows are accumulated when the replication experienced problem on the past year. Most of the rows can deleted. All the replications jobs are functio properly. I...
February 14, 2005 at 8:20 am
Thank you for all your reply. I'll try the one on MSDN.
January 12, 2005 at 5:04 pm
There are basically 2 kinds of D/R, one is original DBA is available (H/W crash, Server crash ...) and the other is only new DBA is available (nature disaster, terror...
November 23, 2004 at 6:40 am
I think this drill to: should we install any software that is not 'cluster aware' on a cluster. As far as I know, none of the AV is cluster aware. I...
November 16, 2004 at 12:47 pm
You can drop an article (table) from replciated database. But, you must drop it from subscription first. The process is like
sp_dropsubscription @publication = 'Publication_name'
October 22, 2004 at 10:11 am
I'm very surprise you have problem with EMC.
I'm assuming using you have 0 +1 if SAN is in place. If not, you may consider pursue this.
If 0 + 1...
October 11, 2004 at 12:18 pm
xp_crypt is the s/w we use, it easy and cheap (compare with other). But, no key management or audit functions
September 28, 2004 at 9:44 am
First of all, thank you for all your input. I also heard some of the vendor package was a hog when installed. Is anyone experience this problem ?
September 16, 2004 at 11:42 am
Thanks for all your reply. I think I will proceed with index hint.
August 18, 2004 at 11:26 am
Adding recompile option to the SP is not a viable solution, the recompile took 600ms. The SP called more than 10,000 times, this will greatly impact my batch windows. I...
August 18, 2004 at 6:43 am
I fully understand what you said. But, I'm looking for someway to prove it and explain why it happen on one day but not the other while the activities are...
August 17, 2004 at 8:19 am
The max. memory may set yo hight, too if you are active/active, you should set that total memory from both instances are less than 1500MB (2048MB - 500MB).
Running a trace is...
July 23, 2004 at 12:01 pm
This seems is a memory leak problem. You need check the connection is closed properly. Check cursors are closed properly. Apply latest jdbc SP (if app use one), there is...
July 21, 2004 at 12:58 pm
I agreed with most above. Backup is more I/O intensive,if you can separate I/O channel with your DB, you should be fine. Some 3rd party solution may increase CPU utilization....
July 21, 2004 at 12:52 pm
Viewing 15 posts - 16 through 30 (of 99 total)