Re: Slow during Inserts

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 09:09:35 -0500

Maybe these will help:

http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring 

-- 
Andrew J. Kelly  SQL MVP
"James Juno" <JamesJuno@discussions.microsoft.com> wrote in message 
news:51E0D23C-3F24-4788-BB9C-1EDF325791A1@microsoft.com...
> DBCC shows no errors and there are no blockings.
>
> James
>
> "Andrew J. Kelly" wrote:
>
>> Sounds like something is blocking.  Run sp_who2 to make sure you don't 
>> have
>> blocking going on.  Have you run DBCC CHECKDB lately to ensure you don't
>> have troubles with the db?
>>
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "James Juno" <JamesJuno@discussions.microsoft.com> wrote in message
>> news:41D366A9-FF2F-4382-B7EF-53DE158089E9@microsoft.com...
>> >I am running insert to a small database of 135mb.  The tables have 
>> >indexes.
>> > The inserts are the simplest insert one can ever do and it inserts a
>> > record
>> > after 10 seconds.  Something that would have been less than a second.
>> > This
>> > problem just started happening.  The process a week ago had no issues.
>> > Nothing has changed.  The disk drives seem to be fine.  Any suggestions 
>> > on
>> > what to do to speed up the server will help. Like I said, nothing
>> > whatsoever
>> > has changed and this same process use to work just fine last week.  Any
>> > suggestions please?
>> >
>> > James
>>
>>
>>

Relevant Pages

  • Re: Slow during Inserts
    ... > SQL 2000 Performance tuning tips ... > Disk Monitoring ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Performance
    ... SQL 2000 Performance tuning tips ... Disk Monitoring ... Andrew J. Kelly SQL MVP "Shabam" wrote in message ...
    (microsoft.public.dotnet.framework.performance)
  • Re: Performance really poor if calling data from sql clients
    ... What is the compatibility level of the db? ... Andrew J. Kelly SQL MVP ... profiler to see what is happening on the sql server end. ...
    (microsoft.public.sqlserver.clients)
  • Re: Log file wont Shrink in Simple Recovery Mode
    ... What does DBCC OPENTRAN() say? ... > Andrew J. Kelly SQL MVP ... As I stated the recovery model is set to simple so it ...
    (microsoft.public.sqlserver.server)
  • Re: Table size and sp_spaceused
    ... It's just that reindexing does nothing for blobs in 2000 but I am pretty ... Andrew J. Kelly SQL MVP ... "John McLusky" wrote in message ...
    (microsoft.public.sqlserver.server)