SQL Server insert issues - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server insert issues

Author

Topic

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2004-11-10 : 09:56:17

I have a machine (see winmsd info below) that is running SQL Server 7.0.1063
it is a replacement for a much smaller and slower server that we were having problems with .

My problem is that I am still having the same issue.
There are at any one time between 100 and 400 connections to the database with 1/2 of these doing inserts into the same table (CDR Call detail records). Occasionally we have a short period usually less than 1 min where the database refuses connections and the applications writing to it time out.
I can find no information in the SQL Server Error logs or System Event logs.
The only thing I can find that seems to be happening at approximately the same time is that the pagefile seems to be very busy. Other Queries inserts, deletes and updates all work well during this outage it is only this one table I am having trouble with.
I have archived the data and truncated the table to the last 30 days data but am still having the same issues.

Any help you can give would be greatly appreciated.

OS Name Microsoft Windows 2000 Advanced Server
Version 5.0.2195 Service Pack 4 Build 2195
OS Manufacturer Microsoft Corporation
System Name XXXXX
System Manufacturer Dell Computer Corporation
System Model PowerEdge 2650
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2790 Mhz
Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2790 Mhz
Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2790 Mhz
Processor x86 Family 15 Model 2 Stepping 9 GenuineIntel ~2790 Mhz
BIOS Version Phoenix ROM BIOS PLUS Version 1.10 A17
Windows Directory C:\WINNT
System Directory C:\WINNT\system32
Boot Device \Device\Harddisk0\Partition2
Locale United States
User Name XXXXX\Administrator
Time Zone Eastern Standard Time
Total Physical Memory 2,096,560 KB
Available Physical Memory 67,732 KB
Total Virtual Memory 5,609,940 KB
Available Virtual Memory 1,452,616 KB
Page File Space 3,513,380 KB
Page File C:\pagefile.sys

chadmat
The Chadinator

1974 Posts

Posted - 2004-11-10 : 12:06:44

My best guess would be blocking since all of the writing is happening on the same table. But the Pagefile activity suggests that you are running out of memory.

Those are the 2 areas I would focus on.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2004-11-10 : 12:48:50

quote:
Originally posted by chadmat

My best guess would be blocking since all of the writing is happening on the same table.

No I have checked during the outages and there are no Process Id's that are blocked or blocking.

quote:
Originally posted by chadmat

But the Pagefile activity suggests that you are running out of memory.

Those are the 2 areas I would focus on.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

As for memory there is 1.5 gigs allocated to SQL Server.
How much would it need? and what is the best way to see how much of the allocated memory SQL Server is actually using. Because it is grabbing the whole 1.5 gigs at startup.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources