I wondered in anyone can help with the following problem that i'm
experiencing, i'll try to provide as much info as possible and any
suggestions would be appreciated.
I have just started at an organsiation and there seems to be slow

I have two servers - a web server and a data server. I have a web service on
my web server that receives a request for information on anywhere from 1 to
60,000 products. I'm looking at a couple of different approaches for
querying the database for the product information on the 1 ...

Given 3 tables...
create table Category
(
   lngCategoryID int not null

I am using SQL 2005
So when i run the query below to list all my active requests and at the same
time have profiler running that filters on duration > 5 secs, I see some
sprocs show up in profiler that has a total_elapsed_time > 5000 in the query

We have a web server running against a SQL Server database and the pages are
taking around 5 seconds to load. We want to be able to identify why this is.
The first place to start we think is the database. Are there any tools that
make it easy to identify any bottlenecks with SQL ...