It depends mostly on what kind of databases you have and what amount of inserts/updates you have on your data.

It also depends what people are expecting of you if anything...

I've ran another trace (only 15 minutes) to see the results of the Memory\Page Reads/sec. Here's the result:

Average 2.2627

Minimum value 0.0000

Maximum value 41.4943

For the moment my users are not connected...

I didn't had time to include the SQL code yesterday, so here's the code.

(It could also be helpfull for other purposes)

CREATE PROCEDURE [dbo].[SP_AddRecord]

@FIELD1 INT,

@FIELD2 VARCHAR (50),

@RETRY INT=10 --Times to...

Depending if you use this function for inserting new data, you could also create a SQL stored procedure to whom you pass all the values as parameters. Then you can...

---- UPDATE ----

I ran an SQL trace and didn't find any Stored Procedures or Queries taking over 100 ms. So for me from a SQL point of view everything looks...

Sorry that I forgot to add the Hard page faults counter in the initial message. (I forgot to paste it over from the 2nd trace file)

Memory\Page Faults/sec

average ...

Apart from the HP Insight Manager we don't have anything runnning on this server. But we have it also running on our development server where we don't have the problem.

The...