Thank you all for your valuable info,

a)From last two days i have observed that when i run the SP_who2 ,for one of the databases(reporting db that application facing performace issue) ,so may SPID is runnning on it and they are in sleeping status and Awaiting command.

and when ran the below command

select * from sysprocesses where cpu>0 order by cpu desc

i could see one spid that is taking high cpu and waitype is Pageiolatch.

Lastwaittype Waitresorce dbid cpu phycical_io

PAGEIOLATCH_SH 12:1:613705 726765 182888

b)One more thing i observed is ,Windows server is a virtual server and has only 1 CPU (1core) ,

will this two be the reason for cpu problem

Please suggest me.

Many Thanks