MS SQL optimization table design recommandation with huge data records
===

Somehow my database is too slow when writing.
Currently I have used 319MB which has 2,127,227 records  within it. The first couple days my computer was able to insert couple thousand record per second and now it taking me forever to insert 1 thousand records, now it taking 165 seconds to insert 1 thousand records(0.165 per record). I need to be able to insert 10,000 per minutes(0.006 per record)

Please see the design of my table  and server specs below and let me know if you can help me to optimize this.  Thank you.


Current usage report
Records 2,127,227
Reserveed KB 323,088
Data(KB) 177,088

My table designed is like below, i to index[LoginID] ASC,[ProductID] ASC, [ProductModifiedDate] 

    GO
    /****** Object:  Table [dbo].[ProductTable]    Script Date: 07/19/2012 23:30:16 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[ProductTable](
    	[ID] [uniqueidentifier] NOT NULL,
    	[LoginID] [int] NULL,
    	[ProductID] [int] NULL,
    	[ProductPrice] [decimal](18, 4) NULL,
    	[ProductModifiedDate] [datetime] NULL,
    	[ProductCreatedDate] [datetime] NULL,
     CONSTRAINT [PK_ProductTable] PRIMARY KEY CLUSTERED 
    (
    	[ID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO
    CREATE NONCLUSTERED INDEX [IX_ProductTable] ON [dbo].[ProductTable] 
    (
    	[LoginID] ASC,
    	[ProductID] ASC,
    	[ProductModifiedDate] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    GO


My insert statement is just a normal simple sql statement, there was nothing special to it.

My hardware
I have a 2 Quad 2.83 Ghz with 16GB DDR3 RAM with the MS SQL 2008 R2 express edition. The CPU is running at 25% capacity when insert these records.


Please let me know how to optimize this table. I really need to be able to search through all of these columns so I think indexing these columns are very importance and I have to keep the record up to 30 days.

I though the MS Express edition can support 10GB of data.



