lol - no worries mate. Unfortunately I have to make some sort of estimate of hardware quoted to me based on the proposed activity of the server.

I found the solution from this hp article http://www8.hp.com/h20195/v2/Getdocument.aspx?docname=4AA4-2072ENW I am able to calculate Cpu consumption core rate at 360 mb/s

from the link:

http://www.microsoft.com/en-us/sqlserver/solutions-technologies/data-warehousing/reference-architecture.aspx

under reference guide click SQL Server 2012 Fast Track Data Warehouse Reference Guide. That will open a document that talks about CPU Consumption Rate and how...

I had a problem very similar to yours.

Do you have Operations Manager by any chance?

I do and operations manager was probing a database every 15 mins for stats info. The...

I did what I believe was the 2005 sql server equivalent (MSCA with sql server elective) years ago and they said the same thing about needing DBA experience to pass...

Imeant prevent a delete from happening... but if that happens would I see the error column in profiler be something other than zero for the delete statements?

can it cause to delete incorrectly?

thanks!:-)

will that get shown in profiler under user error messages ?

or perhap the errorlog?

thanks.. database tuned and running much faster.

what is the query waits server setting about then?

Also when using -1 (default value) it is 25 * the query cost it takes to...

Since I removed mirroring from the archive database the queries are performing much better. Thanks heaps for helping me out with that! 🙂

I do have a question though (just to...

To be totally honest once I found those couple of insert statements being slow in the stored procedure I concentrated on why they are causing slowness. Perhaps if I watched...

I forgot to mention a couple of other things.

My infrastructure guys tell me they see no problem with the network link between principal and mirror.

A few times I continously pinged...

Its all good - I appreciate any advise you can give.

Anyway I sent you two procedures because I think our archiving process might be involved with causing the issues. Apparently...

yes that right we are getting complaints of timeouts. The stored procedure doing these inserts contains most of the longest running queries.

I was just asking that question

if it was...