Viewing 3 posts - 1 through 3 (of 3 total)
Raid 5 will be slower than Raid 1,
the only way to gather the time-differences/i-o
differences would be to run something like:
Performance Montior with disk performance stats switched on,
looking at...
April 22, 2002 at 2:42 am
Hi All,
Triggers-> Should be light and bulletproof -> But at what point is it better to encapsulate the business logic/process logic into the SP for performance reasons.
Info: The only problem...
April 5, 2002 at 9:00 am
Hi,
I only see two problems here:
1) Triggers also cache the execution plan on SQL 2000-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_7cmm.asp
2) Preventing direct data-manipulation does not result in a performance benefit.
What are the direct...
April 5, 2002 at 6:15 am
Viewing 3 posts - 1 through 3 (of 3 total)