CPU Skew Query


CPU Skew Query

Can ny1 plse. help me with how do I calculate the cpu skew for a specific query..

Also, can u plse. specify clear defn of the word skew..

Also, help me with data dictionary tables whioch can be used to audit/ track users actions..Who dropped a particular table, last access to a table, etc etc...


Re: CPU Skew Query

In general, skew is ratio of average to Max utilization (true CPU/Perm). However, this is different from Suspect queries which is more a comparison of IO and the CPU per request. There are several formula that you could look up on internet to find this information.