Search Results

Thread by: HarryArchibald, Feb 20, 2003, 7 replies, in forum: Performance Tuning for DBAs

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...

Thread by: HarryArchibald, Feb 18, 2003, 2 replies, in forum: Performance Tuning for DBAs

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...

Thread by: HarryArchibald, Feb 18, 2003, 2 replies, in forum: T-SQL Performance Tuning for Developers

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...

Thread by: HarryArchibald, Jan 15, 2003, 9 replies, in forum: Performance Tuning for DBAs

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...

Thread by: HarryArchibald, Jan 3, 2003, 8 replies, in forum: Performance Tuning for DBAs

Here is a good one for a Friday evening. I began analysing a database, not designed by myself, for superflouous indexes. As I understood it,...

Thread by: HarryArchibald, Dec 5, 2002, 2 replies, in forum: Performance Tuning for DBAs

I am trying to trace what a 3rd party trigger is doing in the database. I can see from the code that is uses temporary tables and updates these...