Search Results | SQL Server Performance Forums

Trans/Sec for each database on a machine

Thread by: chinnis, Jun 3, 2004, 2 replies, in forum: Performance Tuning for DBAs

Hello. I wanted to find transactions/sec for every database on a server between 6am and 6Pm.. i found a way in getting this using sysperfinfo...

How transactions are written to the disk

Thread by: chinnis, Feb 8, 2004, 3 replies, in forum: General DBA Questions

Hello, I am not clear on some things one is if you are inserting 100 records and commiting that transaction first it writes to the log file and then...

Active/Passive Clustering Scenario

Thread by: chinnis, Nov 25, 2003, 6 replies, in forum: SQL Server Clustering

Hello, In an active/passive clustering scenario when the node1(Active) failsover to node2(secondary)do the sqlserver stop and start and i think the...

Memory Config

Thread by: chinnis, Sep 5, 2003, 3 replies, in forum: Performance Tuning for Hardware Configurations

We have system with more than 4gb(Sql2kEE and Win2kAdv Server) we are using 3gb switch in the boot.ini and we are using -g startup sqlparameter does...

using memory more than 3gb

Thread by: chinnis, Jun 21, 2003, 10 replies, in forum: Performance Tuning for DBAs

Hi, We have a sqlserver2000sp3/win2k advanced server machine which has 4gb of ram so we enabled awe and set the maxmemory to 3.5gb but when i look...

dbcc showcontig

Thread by: chinnis, May 4, 2003, 5 replies, in forum: Performance Tuning for DBAs

I am running dbcc showcontig on a database ,i got the results and i am not sure what to look at to say the indexes are fragmented is it the scan...

blocked processed in Sql Server 2000

Thread by: chinnis, Mar 20, 2003, 5 replies, in forum: Performance Tuning for DBAs

I ran sp_Who2 active i got this result spid kpid blocked waityype cmd 01 03 select it doesn't even show that the processes...