working slow during access sql base report

hello sir

i have configured windows terminal server 2008 r2 with 2 processor and 48 gb ram for 50 to 52 users. all user use maximum ram 20gb. 

i have also configured sql 2008 r2 on it and also iis for web base app.

 i access web basse app and genrate any report.

during genreting report my server working very slow some time is server hang problem.

other time is working normal.

i check sqlservr.exe cup useg

its 20 , 10  ,  30  , 8  , 4  ,  6  , 21

but after complating report its  4 , 5 ,7

i also check iis cpu useg

its 4 to 6 , 8 meximum

plz help me for this problem

 

March 6th, 2014 6:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics