August 4, 2009 at 6:11 am
Hi All
I am using SQL 2005 (64 Bit) edition on a 6GB server ( 5 GB allocated to SQL ), All the databases are stored on the same LUN with RAID_5 ( i know its not good 🙂 ) , Everything worked perfect, until now, there are 2 databases on this server, One database has many tables that has a transaction count of nearly 100/sec, most of this transaction are update on table with reference to a primary key
On the other database i have created a table that has got 4 Columns, first is a primary key varchar (15) and the other 3 are datetime,
This table has only got around 30 transactions/sec, but the problem when an update is been passed from Jave Hibernate, it takes more than 2 minutes to update this row, this is the only table on this table that is been updated,
Update is a straight forward one, update table set Col2=getdate(),col3=getdate(),col4=getdate() where col1=
I have checked the index and then the waits as well, first it was CX packet then i have changed my MAXDROP configuration , this wait has gone, but now its showing me wait on the Disk,
I am a bit confused, i am using the same LUN for the other database on the same server, if there is a problem with Disk then it must affect all tables on that LUN, why is this the only table
Am i looking on the right picture or am i missing something obvious, please guide me
Thanks in advance 🙂
August 11, 2009 at 11:24 am
Hi All
I am just replying my self to find out any luck with this Doubt, its still happening and i cant figure it out ??
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply