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,...
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...
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....
All, In many of my previous places, we just dump whatever MS provides as security updates (Especially the high critical ones) such as...
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....
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...
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...
We have a SQL / Windows Cluster of two db servers. Yesterday, one node crashed and HP recommended upgrading the firmware/driver to the latest...
Our DB server is SAN attached. When i ran the DiskDefrag "analyze" utility, it showed a major portion in RED. My doubt is : By concept, i understand...
Ok..we tried to research this in vain. There is a SQL job in our server which copies that night's backup file (90GB) to another server. This process...
Consider a table with around 4 million rows. Some 15 queries start READ and ONLY READ from this table in the morning (7 of them are complex with lots...
1) This is an interesting trend i have been noticing in my system.. We have been researching on the inconsistent performance of queries (Suddenly,...
As per default expecations before we set the AWE / PAE, the sqlserver memory usage never went above 1.7 - 2 GB. Past weekend, we deployed the AWE...
I see Trev's post on this... But thgt a separate thread might throw some light on my issue, which has a twist.. Getting the exact same issue ! For 2...
We are trying to troubleshoot a performance bottleneck in our DB server. During peak usage times (in terms of reporting and processes run ), we are...
We have 7 tables replicated continously using transactional replication between two SQL servers, which are part of a cluster setup. We get frequent...
Sorry if am duplicating..(Did not see this topic anywhere ) Has anyone made the conversion frm SQL 2000 to SQL 2005 . How did it go? Read that there...
Win 2000 Sp4 SQL cluster. One of the nodes crashed with an error : SCSI bus fault occurred on Storage Box 0, Port 1 of Array Controller in slot 4,...
We have been facing this error for the past few days. There is an automated job which gives READ access to a database, running @ 6 AM everyday. The...
Hi All I have a dynamic SQL built using a cursor (@ variables) For every row fetch from the cursor, i do further manipulations and select data from...
Separate names with a comma.
