sql server 7.0 performance issue

[niall5098]

HI All,

a client has a database which is 46 gb, auto shrink and autoupdate statistics is enabled.

They have issues when they upload data, the job deletes records first before inserting new data.

They recieve the following warning in their log file.


12:41:21:303 - Warning : There are warnings in this buffer.

The insert works but takes a long time.

Could the autoshrink be causing the problem?

Thanks in advance,

 

[baddos]

You don't want autoshrink enabled unless you are low on disk space.

 

[mrdenny]

You never want autoshrink enabled. All that will do is thrash the disks, cause fragmentation, and worsen your performance issues.

What are your auto growth settings set to?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog