Re: Extreme performance issues (SQL Server 2000/ADO.NET/C#)

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 09/15/04 

Date: Tue, 14 Sep 2004 22:10:20 -0400

Have you profiled both SQL Server and your application to find out where all
of the time is coming from? You should run SQL Server Profiler to find out
if the stored procedures are really taking 30 minutes (and what parameters
are really getting passed in -- it could be that something is not getting
properly passed in). If it turns out that the stored procedures are not
taking up the time, you should download a copy of Compuware's DevPartner
Profiler, Community Edition ( www.compuware.com ). Then you can profile
your app to find out what's going on.

When you say you're "using ADO.NET", what does that mean? Are you using a
data reader? Data adaptor? What are you doing with the data once it's
loaded into the reader/data set?

"Jon Rista" <jrista@hotmail.com> wrote in message
news:e9eGyMsmEHA.2864@tk2msftngp13.phx.gbl...
> I posted this on the ADO.NET group, and someone there suggested I post
> it here too. I appreciate any tips.
>
> I'm using ADO.NET in a windows service application to perform a process on
> SQL Server 2000. This process runs very quickly if run through Query
>

Relevant Pages

  • Re: Object Access?
    ... SQL Server does not track this info. ... run Profiler to see what is going on. ... > they are also referenced in quite a few stored procedures and do actually ... > still redundant or obsolete. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: How work Profiler.
    ... In SQL Server 2000, only members of the SysAdmin role are permitted to execute the Profiler utility. ... Other than modifying the system stored procedures that are used by the Profiler utility, there is, to the best of my knowledge, no alternative. ...
    (microsoft.public.sqlserver.security)