This issue has been resolved as there was a change in java code .... the code has been revert back .... not required a professional we hav to belive in...

Wat i hav found tht there is some change in java code as i m a dba ...

..... i dnt no wat are the changes has been made but wat...

i hav used exists but there is no use same result...

...... shud i do 1 thing to check the appication.... some one might changed the coding as it run through...

i m having a job which runs every week and it updates the statics...

........ but still no improvement has been made.

i m hving a clusterd index on the column which cantain some duplicate records may be more than 1000 ....table contain more thn 10 millions of records....

when i execute...

There is no issue wth indexes but i reboot my database server and it was workin fine ... application is on different server ... users fetch and insert data...

this is the query taking time 1st it was taking only 2sec now it takes 40 to 60 secs .... databse size 18 GB ,ram 3 GB

sqlserver taking more...

NT has sysadmin rites so u can disable builtin/adminstrator

i think for this we hav to execute a disk -ye or y command to get the perfect counter sorry i dnt no the full commnad

gail cnt we reinstal sqlserver

Hi paul plz change ur pic

any more suggestions ..... 🙂

Jeff TB free space .... As there was no cluster index wer present in the table and the table were containing non cluster indexes ..wat i did.........

...........created a...

wat u do is jus check indexes with dbcc showcontig and if u are getting the same result drop and recreate the indexes .... and try to create cluster...

About archiving the data u jus need to transfer ur old data to ur history table ...... Archiving Data improves ur performance ..