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 2000 Forums
 SQL Server Development (2000)
 performance monitoring

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2004-11-03 : 15:04:03
Hi,
I have been told to go to a client site and find out why their sql server slows down during/after a data feed. They have a shopping site.

I do know that this is abit unclear but what do I start looking into when I get there?

I do have some clues but I just would like to know how you deal with such an issue.

Thanks

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-11-03 : 15:26:37
http://www.sql-server-performance.com

They have several articles on the subject.
Basically, you'll need to use SQL Profiler in combination with Windows PerfMon to determine what the problem is.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -