Home / server / Questions / 55059
Accepted
scottm
Asked: 2009-08-18 07:27:31 +0800 CST

Why do I have such high overhead when creating tables in MSSQL7?

  • 772

I have an old system running MSSQL7. It takes about 10.5 seconds to create the table below and another 30 seconds to add the index. Is there anything I can do to decrease these times?

CREATE TABLE [dbo].[MyTable] (
    [queue] [int] NOT NULL ,
    [seqNum] [numeric](12, 0) NOT NULL ,
    [cTime] [char] (14) NOT NULL ,
    [msg] [char] (255) NULL ,
    [status] [int] NOT NULL ,
    [socket] [int] NULL 
) ON [PRIMARY]
GO
 CREATE  INDEX [search] ON [dbo].[MyTable]([queue], [seqNum], [status]) ON [PRIMARY]
GO

 CREATE  INDEX [new] ON [dbo].[MyTable]([queue], [status]) ON [PRIMARY]
sql-server

1 Answers

  1. Best Answer

    Are you having any locking issues on the system objects going on when this is running?

    What's the load on the disks look like?

    Any reason that you are running a version of SQL Server that is way out of support? There have been a LOT of performance improvements between SQL 7 and SQL 2008.

    • 1