Please find the attachment for the screenshot(error message)....

On further investigating the High transacttions/sec i noticed it is due to high number of SQL Compilations/sec......It seems some of the statements don't have the Actual Plan and so everytime...

The table has around 17 million records and i am trying to update 1 row at a time

Thanks for the information....My statement recompiles around 6 times a day and it doesn't take too much time(around 2-3 sec)....So i guess i am okay with Statement Recompilations

We use a third party tool called precise i3....It gave me an alert message that a particular table has high number of pages(based upon the pre-defined threshold value).....that's why i...

Thanks for the suggestions

Trasactions in our application generally range between 7 to 40 /sec......The application is not huge.....I am using a third party tool called precise i3(It gives me alert messages whenever it...

Is there any way to decrease the number of pages other than increasing the fill factor??

How is it caused by the bad code???

thanks for the quick reply

Yes, i dropped some of the indexes which are not useful

Regards,

Sandeep

No, i am not running Enterprise edition......I am working on Standard edition 🙁

Yeah...i solved the problem....there were too many indexes on the table.........

Thanks buddy

Thanks guys.....