Anyone knows the difference in performance for a san with 2TB between SATA and FATA for the same number of spindles?
Won't Ata increase cpu...
When inserting into a table using fulltextsearch which tracks changes, the index is not searchable until 20-60 seconds afterwards.
We have a data table which contains data with mixed content, so there is
'<streetname>' and 'streetname' words in the different rows
Yes the service was up and running and you could create a fulltext catalog, then an eventlog error occured related to c000005 which look like a...
fyi I reinstalled sql server + sp's and then everything worked....very strange
windows 2003 updated
SQL 2000 SP4
Administrators of the machine has rights to the fulltext search catalogs.
I have a problem with fulltext search on a fail-over cluster.
Everything seems to work, i can rebuild, populate etc but when i search i get no...
thx for the answer
Do you know any articles which document linear scaling?
so i can provide them as documentation
Does anyone have a good case regarding how much overhead extra discs in raid 1+0 konfiguration ?
if 8 disks give 1040 iops, how many iops can be...
well the problem is that once they have bought the hardware it seems very hard to get it changed, and if i only set up IOPS, throughput and server...
They have 3 FC ports, and i meant the xeon 50x0 line.
Thx for the advice.
Since they have mirror on top of shared disks will it perform as a...
If i only had 8 drives i would 6 for data and 2 for log, i suggest you get rid of the 2 10k drives and replace them with 15k.
Since your batches...
I have a customer which needs new hardware for running sql 2000 and later 2005. I have recommended dual dual-core xeon with 2MB L2, however he...
well it has been tested for SP4 and we have had no major problems, the shared exlusive instead of shared update does not seem to be the problem....
They run every night, i've checked during the day with DBCC SHOWCONTIG that no indexes has a scandensity lower than 75
after some investigation it seems that it is sometimes locking as well, i can see in the trace that has more shared exclusive locks than it used...
No it does not change very much, but duration is mostly approx 1 sec.
I have similar one with 60ms cpu and duration on 9000.
Is there any way i...
In a production environment occasionaly queries which takes too long occurs.
In Profiler the rpc has 753ms cpu, 19000 reads and duration on...
quote:Originally posted by joechang
there will be variation individual rows, depending on whether indexes need to be modified,
also, a write query...
I have an update statement which updates one row in a table.
This gives up to approx 1000 writes, i suspect that it is a number of clustered views...
Separate names with a comma.