Tuesday, May 08, 2007 - Posts

Stored procedures performance issues
08 May 07 03:57 AM | SQL Master | 0 Comments   
Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. Read More...
FILL Factor blurb to decide
08 May 07 03:29 AM | SQL Master | 0 Comments   
As all of us know that while creating Index for a Table there is Option for specifying Fill factor. This option specifies how full SQL should make in the Index Page while creating Index. Why this option is provided, should it not by default 100 ? What Read More...
Using PERFMON to get memory counters, what you need to check?
08 May 07 02:17 AM | SQL Master | 1 Comments   
Refer to AWE if you have enabled the AWE in thsi case. Another piece of advice is if this is not a dedicated SQL Server then make sure you have monitoring MemToLeave information too, as it manage the transaction log requirements. Refer to pages/sec counter Read More...

Search

Go

This Blog

«May 2007»
SMTWTFS
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

Syndication