To find the disk bottlenecks, we need disk read per sec, disk writes per sec, avg. disk sec per read and Ave. disk sec per write.
When we were monitoring disk I/O:
We got min. disk reads per sec, max. disk reads per sec and avg. disk reads per sec.
I think we have to take max. disk reads per sec to calculate the total physical I/Os per disk, but i am not sure....
Please anyone can help me
Thanks a lot
QUESTION 1:
I am getting high DPC utilization in Performance Moniter. What is DPC
(seems to be CPU bound). How can I tune my system to be use this resource?
QUESTION 2:
Is the equation below correct?
Total elapled time = cpu + memory + disk + network + program time
According to query analyzer, my elapsed time is ie 100
BUT my cpu and disk time totals only 20. Where is the rest of the
elapsed time coming from??
Thanks
I am about to heavily index a table and have to include atleast 3 to 4 olumns in the fulltext index for this table.
The table is updated very frequently and the also the columns that are involve in the fulltext indexing undergo frequent updates.
As of now, I can't avoid using full text indexing as these columns are very very lengthy and basically contail text.
The users of the database will give some key words as the search criteria
to get infomation as to what they are looking for.
How frequently should I update my full text catalog.
This is a scenario where the full text is operating on various tables and
each of thses table might be containingaround 300,000 to 800,00 rows.
I would appreciate an intelligent siggestion as I need it as soon as possible.
Thanks and have a wonderful time ahead.