Maybe concider running PSSDIAG and get a complete view of perfmon and profiler ...be carefull to look at task manager..rather make sure.

WOW .....I query our 3.6 billion row table and all my reponses are sub second ..with out partitioning or splitting data in a federated concept neighter partitioned views ...

Good design...

:hehe:

Hi

Please never only use the errorlog as a main monitoring component.

I suggest the following:

Review the SQL server 2000 operations guide (monitoring chapter) and familiarise yourself with monitoring....

Hi

Ok something very weird on SQl 2005.

When I do the same on SQL 2000 with the qualified names then I only get execution context hits 🙂 .

But on...

Hi

I thought so , but at 1 AM in the morning I did not try this ...I will test thanks

First of all how static is your data that your view refrences ? .

By recompiling your view the query optimizer uses the statistics and all kinds of good stuff while...

Hio

Your best bet here is to take the following approach.

Even a software vendr states that is was only a software upgrade you will be surprised to see what actually...

Hio

Agree with George. You will have to look at the sysprocesses table and look at the waitstats and the waitresources while it is blocking to see why it is blocking.You...

Hio

I agree with all the previous statements the other guys made espesially having indexes on individual columns and then a covering index on them as well. There is no real...

Thanks for the feedback

The CPU one is kinda tricky at this stage ...I think this might be because of hyperthreaded cpu's ..I hate them .

W

WOW latches is a very broadbased discussion and sometimes very difficult to explain .

As the previous replay you had states it is lightweight "locks" ...some people do refer to...

Thanks for the reply guys ...I always like the undocumented commands

I know what tools I can use   

...I was looking for something deeper ..to realy get into it from a thread perspective ..but...

Hi

Thanks for the reply .

What do you mean by " I hope with SQL 2000 you can't get this information "

I realy need this on 2000...