App too slow to get screens with only one user

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

App too slow to get screens with only one user

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-15 : 02:36:00

Hi,
I have web app and i m only user hitting here but still i m facing problem with long time waiting to get screens...

I chked with profiler here i m getting rows besides my app related activity and it is

Audit Login -- network protocol: LPC
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
Report Server SYSTEM NT AUTHORITY\SYSTEM 3136 53 2008-05-15 12:02:38.217
RPC:Completed declare @p1 nvarchar(64)
set @p1=NULL
exec GetDBVersion @DBVersion=@p1 output
select @p1 Report Server SYSTEM NT AUTHORITY\SYSTEM 0 2 0 0 3136 53 2008-05-15 12:02:38.217 2008-05-15 12:02:38.217 0X0000000001000000180047006500740044004200560065007200730069006F006E003800000082001800E7516E00760061007200630068006100720028003600340029001400400044004200560065007200730069006F006E00
Audit Logout Report Server SYSTEM NT AUTHORITY\SYSTEM 0 9456 0 5003 3136 53 2008-05-15 12:02:38.217 2008-05-15 12:02:43.220

what it means???

T.I.A

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-15 : 03:25:41

Do you have reporting services running? How long are those events taking?

--
Gail Shaw

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-15 : 04:14:58

yes.. its running and only these rows for report server I am getting again and again...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-16 : 04:12:11

What about queries from you app? Look at those and see which are running long.

If you want to test, shut reporting services down and see if the app speed improves

--
Gail Shaw

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-05-19 : 02:22:41

ok.but will that impact on other services..i.e. my app using SSIS.

whats purpose of running reporting services everytime????

if we shut down this reproting service forever?????

T.I.A

Regards

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-19 : 04:06:36

I never said to shut it down forever. Shut it down briefly (10-15 min) and see if performance improves. If it does, then report services is to blame. If performance remains very slow, then there's another cause

--
Gail Shaw

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources