Yes check with vendor before adding clustered index. There is a way to figure out if all records on a table are unique - perhaps one of the others...

Hi there the wait stats show the CTXPACKET when you use all CPU's -- well thats what i have seen in my case. What else can you show as...

Finally got to the statistics

AVG DISK SEC/READ --- This disk is my SQL Data Files

Took the results * 1000 to get the ms

So this is very bad these...

So on 32 bit the same weblogic and drivers is running but on 64 bit it slow.

Same sql query - how you measuring this in Query analyzer

Interested - using...

If you can go straight to SQL 2008 and Windows 2008. I wrote the entire steps by following Dell threads they have the entire instructions layed out. It appears...

Put on profiler and capture what is running at this time.

Got it ignore all this

Raid 0 -- I/Os per disk = (reads + writes) / number of disks

Raid 1 -- I/Os per disk = [reads + (2 * writes)]...

Thanks for your guidance i be away now measuring like crazy.

The 12 i think i found on some thread what to check for

See little confused if i have to do these calcuations too? with the avg results.

Raid 0 --...

345 milliseconds.

So that is not < 12 ms so leading me to disk problem here. (Need to do this for a good week) and see if it was...

So take my results * 1000....why the 1000 sorry being dumb over here.

Avg Disk Sec Write

0.0031275943.127594

0.345726198345.726198

0.0001203490.120349

0.00016530.1653

Hmmmm the 345 seconds is a big red alarm if < 12 ms is something...

Right click sql server properties and change Memory MAX setting to x gig.

May have to reboot if SQL 2000 i know 2005 you do not need to.

do group and having count(*) > 1...wouldn't worry about space i be more interested in getting rid of duplicates. You can copy out to a temp table do the...

sp_who3 is out there do search i not got code in front of me then run this in query it at least gives you some of the sql code..

Hmm when node goes down and not brought up it takes a while to build it...but yes the users will not be able to get it if it did not...