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...
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...
In an active/passive clustering scenario when the node1(Active) failsover to node2(secondary)do the sqlserver stop and start and i think the...
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
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...
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...
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...
Separate names with a comma.