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)
 Server is slow in retrieving data

Author  Topic 

manojbavikati
Starting Member

3 Posts

Posted - 2009-08-05 : 15:35:31
Hi friends,

I have an application which continuosly take data from the sql server 2005 and show it in windows forms. It has lot of records to bring. It works fine . I got a wierd problem these days.

The application takes forever to bring the data during afternoons and it works fine during moring time till 1 PM . Is there anything that i need to check to see why the server is doing like this ?

I am just a developer and we dont have sql admin in our company ... your help is greatly appreciated.


Manoj Bavikati

shah429
Yak Posting Veteran

52 Posts

Posted - 2009-08-05 : 17:59:23
Do you know how to performance monitor? If not google it, worth a try.
Go to Top of Page

manojbavikati
Starting Member

3 Posts

Posted - 2009-08-06 : 10:50:56
Any other suggestions apart from Performance Monitor. I dont understand them.

Manoj Bavikati
Go to Top of Page

shah429
Yak Posting Veteran

52 Posts

Posted - 2009-08-06 : 17:28:00
Use profiler to find out what is running during that time that is causing the slowdown
Go to Top of Page

manojbavikati
Starting Member

3 Posts

Posted - 2009-08-07 : 09:20:50
Sure i will...

Manoj Bavikati
Go to Top of Page
   

- Advertisement -