Viewing 9 posts - 1 through 9 (of 9 total)
Stay tuned; low level physical checks are running as this post is written and this will hopefully shed some light over the mysterious messages. If time permit it, chkdsk will...
March 29, 2006 at 10:29 am
Thank You for all input, but none of them is relevant to this installation since it's a very closed and dedicated environment (at a customer site).
The problem is solved right...
March 23, 2006 at 8:10 am
Should have mentioned this in my initial post, but this is a failover cluster in an active-passive configuration running SQL2k sp3a on Windows 2000 Server Ent.
Could the same happen if...
March 15, 2006 at 4:04 am
From my experience this is typically caused by network communication problems between the clients and the databaseserver. Try to see if the server has a lot of bad packets and...
February 9, 2006 at 1:36 am
I don't have similar experience, but from what You tell in Your previous posts, I would recomend that You decrease the growth value instead of increasing it. Try to set...
December 7, 2005 at 3:02 am
You could place the backupfiles on a fileshare on another server, NAS, SAN etc. to isolate the backup physically from Your db-server. If You consider this, You have to run...
December 1, 2005 at 2:06 am
Given the fact 50/50 read/write, I would have done it like this
-2x Raid 1-sets (mirroring)
-Raid 1 set #1
-OS and RDBMS
-Datafiles (mdf)
-Raid 1 set #2
-Logfiles (ldf)
-TempDb
If Your...
November 30, 2005 at 2:53 am
You should also check the following:
-if any backup software is running a file level backup of Your databasefiles (mdf,ldf,ndf)
-if any antivirus software is scanning Your databasefiles
Both could prevent (by placing exclusive locks...
November 15, 2005 at 3:14 am
Or You could run the undocumented but otherwise well known DBCC SHOWFILESTATS that returns the total number of extents allocated and the number of free extents for the defined datafile(s). From...
November 8, 2005 at 1:59 am
Viewing 9 posts - 1 through 9 (of 9 total)