Low Performance after running for a long time

18 May 2005 4:21 AM

tl

Hello,

I setup a SQL Server 2000 (SP3) for data migration. After running a
long time for data insertion, the server ran slower.
My migration program did not use transaction and the log file of the
database
did not grow.
However, after i have restarted SQL Server, the server ran extremely fast
and became normal for a short period.
I found that many people also came cross this problem. (The performace will
be lower after the server runs for a long time)
But I still do not have a solution for the performance tuning.

Could anyone help me ???

Thanks ahead of time~

18 May 2005 6:28 AM

Uri Dimant

tl
Can you show us your INSERT statement?
Have you checked TEMPDB database ? Did it grow?
If it is an issue , visit Aaron's web site www.aspfaq.com to find more
info.

Show quoteHide quote

"tl" <x**@xxx.xxx> wrote in message
news:efavgB2WFHA.3320@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> I setup a SQL Server 2000 (SP3) for data migration. After running a
> long time for data insertion, the server ran slower.
> My migration program did not use transaction and the log file of the
> database
> did not grow.
> However, after i have restarted SQL Server, the server ran extremely fast
> and became normal for a short period.
> I found that many people also came cross this problem. (The performace
will
> be lower after the server runs for a long time)
> But I still do not have a solution for the performance tuning.
>
> Could anyone help me ???
>
> Thanks ahead of time~
>
>

18 May 2005 7:28 AM

tl

Thanks in advance.
I just use insertion statement in this format " insert into [Table]
(xxx,yyy) values ('xxx','yyy')"
after inserting around 30,000 records, the performance of insertion becomes
low.
Then, i have to restart SQL Server.

TEMPDB database ? I havent checked if it grows.
Why is it related ?

Show quoteHide quote

"Uri Dimant" <u***@iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:%23g2ytL3WFHA.1***@TK2MSFTNGP10.phx.gbl...
> tl
> Can you show us your INSERT statement?
> Have you checked TEMPDB database ? Did it grow?
> If it is an issue , visit Aaron's web site www.aspfaq.com to find more
> info.
>
>
> "tl" <x**@xxx.xxx> wrote in message
> news:efavgB2WFHA.3320@TK2MSFTNGP12.phx.gbl...
>> Hello,
>>
>> I setup a SQL Server 2000 (SP3) for data migration. After running a
>> long time for data insertion, the server ran slower.
>> My migration program did not use transaction and the log file of the
>> database
>> did not grow.
>> However, after i have restarted SQL Server, the server ran extremely fast
>> and became normal for a short period.
>> I found that many people also came cross this problem. (The performace
> will
>> be lower after the server runs for a long time)
>> But I still do not have a solution for the performance tuning.
>>
>> Could anyone help me ???
>>
>> Thanks ahead of time~
>>
>>
>
>

18 May 2005 7:35 AM

Uri Dimant

tl
Do you have any indexes defined on Table? If you do , it may slow inserting
..
When SQL Server performs DML it may create a 'worktable' for any operations
for instance ORDER BY clause
Visit at Aaron's site and will find more info about that.

"tl" <x**@xxx.xxx> wrote in message
news:e7QWKq3WFHA.3712@TK2MSFTNGP09.phx.gbl...
> Thanks in advance.
> I just use insertion statement in this format " insert into [Table]
> (xxx,yyy) values ('xxx','yyy')"
> after inserting around 30,000 records, the performance of insertion
becomes
> low.
> Then, i have to restart SQL Server.
>
> TEMPDB database ? I havent checked if it grows.
> Why is it related ?
>
> "Uri Dimant" <u***@iscar.co.il>

> > tl
> > Can you show us your INSERT statement?
> > Have you checked TEMPDB database ? Did it grow?
> > If it is an issue , visit Aaron's web site www.aspfaq.com to find more
> > info.
> >
> >
> > "tl" <x**@xxx.xxx> wrote in message
> > news:efavgB2WFHA.3320@TK2MSFTNGP12.phx.gbl...
> >> Hello,
> >>
> >> I setup a SQL Server 2000 (SP3) for data migration. After running
a
> >> long time for data insertion, the server ran slower.
> >> My migration program did not use transaction and the log file of the
> >> database
> >> did not grow.
> >> However, after i have restarted SQL Server, the server ran extremely
fast
> >> and became normal for a short period.
> >> I found that many people also came cross this problem. (The performace
> > will
> >> be lower after the server runs for a long time)
> >> But I still do not have a solution for the performance tuning.
> >>
> >> Could anyone help me ???
> >>
> >> Thanks ahead of time~
> >>
> >>
> >
> >
>
>