That makes sense. Thanks very much for your help with this.

Im seeing the following value in Perfmon:

2754.68731587591

Im seeing the following value in Idera:

983.00

These are both for the same Drive and same Time.

I dont believe I have the patch applied; however...

Great! Thanks for your help.

Hi Robert, thanks for your reply.

I'm taking the Disk Reads from the following performance counter:

PhysicalDisk(D:)\Disk Reads/sec

In Idera Im selecting:

Reports > Analyze > Resources > Disk Details.

Im selecting the same...

Ok thanks, thats what I was thinking too.

Im looking into collecting performance data over a period of time, and just wondering if there are any pro's cons' of using...

That makes sense, thanks for your help.

Thanks very much for your help. Thats exactly what I needed.

So, there is no option other than Full Text?

Ok thanks.

With the FTI being stored seperately from the base table; how does the FTI data link back to the base table?

Let's assume I have a table with a Clustered...

Thanks, thats exactly what I needed.

Do you know if FT Indexes are suitable for high transactin databases. Are there any limitations at all?

Ok thanks.

So, the data included in the FTI is stored in a completely seperate structure (catalog). This structure contains all of the available search results for the specified columns, and...

They can be updated manually, using a trigger for example, which fires on the insert. Also, i dont need the catalog updates to be real time.

The issue was, I...

Ah Ok, you dont know the answer. Could have just said.

Thanks for your help anyway.

There are ways around this, so it shouldn't cause a problem.

full text indexing in this instance proboably won't help you as you need to update the catalogues before the results appear in the search - ie the search isn't realtime.

If...