There are other factors to be considered in the running time of a stored procedure. The overall load on a server can have an effect on the run time...
Thanks for the ideas guys. I already had a trace on for Process: Page Faults/sec but that should no link to Memory/Pages/Sec. We have no...
The server hosting a database periodically runs slowly. This seems to coincide with a high (approx 2000) value for Memory/Pages/sec which last for...
Perfect. Cheers.
I am investigating the performance of a server running a third-party app. I was doing some ad-hoc monitoring when I noticed that 8 processes were...
I am investigating recompilations of stored procedures on a production server and found one stored procedure that is recompiled hundreds of times a...
I am trying to confirm the effect of using set ansi_nulls in a stored procedure. BOL states that 'When invoked inside a stored procedure, the...
There is a rapid blocker script from MS at support.microsoft.com/servicedesks/ webcasts/wc011502/WC011502.ppt. I found this gave back info but it...
You could add a trigger to the that checks that the status has been inserted, and use xp_sendmail to e-mail a record.
We 6 publications replicating to 12 sites worldwide. Besides the info found on this site, the info I wish I knew 18 months ago is: Create foreign...
John, The indexes are rebuilt every night and showcontig shows little fragmentation. My concern is that decreasing teh fill factor will increase...
I do not know of a way to stop the data beign accesses but what you could do is to audit data access. This will not stop access but will allow any...
Something like this inside SPA should work. declare @returncode smallint exec @returncode =spb if @returncode <>0 DO SOMETHING
I am little bit oput of practice with Transaction Replication. My understanding, however, is that the new snapshot need not be applied, as long...
If using Merge Replication, the snapshot does not have to be re-applied, as long as there are no changes to the Subscriber. The MergeAgent can be...
My understanding is that ,when using Windows 2000, diskperf does not need to be used. I monitor 14 servers, all using Windows 2000, and they all...
Thank you Brad, a good answer as ever. I am planning to measure fully the number tomorrow, but currently I'm seeing a similar figure to yours, with a...
When using replication, a column can only be added or dropped using stored procedures. Unfortunately, this invalidates the above solution. This has...
Replication is mimicking database behaviour. If a new column is mandatory and is being added to a table that already exists, then what values...
I am evaluating the Entegra audit tool. One of things it shows is that a number of different tables result in Page Splits. I realise it is like...
Separate names with a comma.
