I'm close to tearing my hair out with this one and Im sure its properly quite simple... What facet/condition do I want to use to ensure only tables...
1. using perfmon to measure the amount of page splits per sec ... Im told that a too many may indicate poor indexing etc ... so how many is too many...
Mohammed thank you .. really appreciated :-) best wishes simon
Hi Ive got piece of sql that selects a list fo client ids from a table using a cursor and then deletes data from a a series of tables based on that...
thank you both for the advice.. appreciated :-) simon
Under what circumstances could you justify/allow a table to be a heap ? a temporary dumping ground that was written to far more than it was read from...
Hi Ive just gone through throgh the sql server error logs and there are no entries for SQL browser thanks & regards Simon
the browser is indeed running .. SQL 2000 is the default instance, SQL 2005 a named intance,, Out the box configuration .. I have not changed tcp...
I keep seeing "The SQLBrowser service was unable to process a client request." appearing in my windows appliocation log.. any ideas as to what this...
thanks for the reply , much appreciated :-) .. especially clarifiying total server memory no not Free pages (unless it has been renamed ?) SQL...
Hi satya thank you .. I'm aware of what causes them.. what I want to know is if I want to measure page faults caused by sql processes rather than any...
Again a moment when all is running smoothly so time to reflect / brush up on knowledge etc etc I have a couple of questions regarding perfmon ,,,...
Hi thanks for the replies SQL 2000 sp4 Enterprise Edition Win server 2003 4gb on the box No AWE etc enabled Its set to use 3gb constantly (Im...
I'd always thought that, for example, a single server running nothing but SQL Server youd use dynamically manged memory and make sure you left some...
Hi Im using perfmon and seeing relatively high amount of page faults.. I want to narrow this down to how many are caused by SQL... maybe an easy...
Separate names with a comma.
