It is a two-node cluster with 8 GB RAM on each server. (SQL 2000 EE on Win 2000 Sp4) Let's say the allocation is : Node A - 4.5 GB, Node B - 2.5 GB,...
Thanks mate..this was the issue Thanks, Anand.K Purity, patience, and perseverance are the three essentials to success and, above all, love - Swami...
One of my cluster services keeps failing when started using a Cluster account "Cluster_SVC".But, if i start the service with my account it runs. Both...
Not sure how much this will suit you. From personal experiences, i have separated this process from SQL Server. I have simply created a batch file...
RESOLVED Found from the SQL Logs an error message regarding privilege I found this reference online : Cannot use Address Windowing Extensions...
All, Our Prod is Win 2000 Sp4 with SQL 2k Sp3a. We have a sudden issue where SQL Server has gone back to its default behaviour 1.7 GB RAM usage....
Thank you Luis Thanks, Anand.K Purity, patience, and perseverance are the three essentials to success and, above all, love - Swami Vivekananda
All, In many of my previous places, we just dump whatever MS provides as security updates (Especially the high critical ones) such as...
the irony is database will not get dropped, as it is used for replication.. Replication cannot be dropped as the database itself is inaccessible.....
<img src='/community/emoticons/emotion-1.gif' alt=':-)' /> yeah..it was very frustrating when i saw the error log and knew what happened.<br /><br...
Now, this is a strange combination of events:<br /><br />1. Database A is publisher in the server X. Datafile is on G: and Logfile on H:. <br />2....
This is a great tip Joe. Thanks. Thanks, Anand.K Purity, patience, and perseverance are the three essentials to success and, above all, love -...
Joe, we have an active-active cluster (Win 2k Advanced Sp4). On one node, this physical disk counter is present BUT on the other node it is not...
can anyone pls point me in the right direction, how to accomplish this... we need to get all the physical disk counters in one of the cluster...
""Firstly try to avoid using the AV for SQL Server related files and avoid any scanning operation by AV during the SQL Server busy hours "" Thanks...
I presume : Database A has come from server A to server B.. So, the general practice is to do a complete dropuser first and then run adduser in the...
That is a great article by Ken Henderson. .learnt a lot! Thanks for sharing.. Thanks, Anand.K Purity, patience, and perseverance are the three...
Could this registry change (IRPStackSize) be effective in Source server ? All along, we hav been making changes in the target server (as per many...
Sorry if i am repeating this question.. I tried to enable disk monitoring using Diskperf -Y (Win 2000 Sp4 Server). It did give a message : << Both...
Thanks for the suggestions guys. We went ahead and applied last weekend on the other cluster node too. We are monitoring for messages. The problem...
Separate names with a comma.
