timeout - SQL Server Forums

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)

timeout

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-16 : 03:15:10

I get occasional timeout on a web application which points to a sql server database.
To start investigating the cause, I am thinking to run the profile throughout the day and save the queries into a table and then analyse the times for each hit.
Any thoughts please?
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-16 : 03:23:02

its better to track down which specific queries causes timeout and then analyse their performance using execution plan rather than runing profiler for a day
Running profiler will slow up db and might cause response time of application to go up.

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-16 : 03:32:20

Ok, thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-16 : 06:07:34

Have you update stats?

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-16 : 06:30:33

For business reasons, the database is restored by a .bak file from another location every few days.
Knowing this, is update stats still required?
Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-16 : 09:42:51

quote:
Originally posted by arkiboys

For business reasons, the database is restored by a .bak file from another location every few days.
Knowing this, is update stats still required?
Thanks

Yes.

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-17 : 15:50:25

I know I can do update statistics table1
How do I update statistics for all the tables.
Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-17 : 17:45:31

[code]

Use databasename
Exec sp_updatestats

[/code]

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-01-18 : 06:21:44