The problem is when i capture trans/sec in perfmon i see 3or 5trans/sec where as in trace i see a lot of sql statements completed. I don't...
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...
so the buffer cache is in memory structure right not on the disk cache am i correct
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...
Argyle, I have a question in the active/active scenario node1---active node2--active If node1 fails it failsover to node2 then the node will be...
Argyle, You understood the question correct is that the same in active/active scenario .
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...
can you explain briefly what it does because with 3gb switch it used to take 2.8gb now we have this -g384 and sqlserver is using only 2.5gb is there...
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...
we are using win2k advanced server so how much ram we have ex(8gb)max 1gb of ram is used by OS what ever we do,is that correct Thanks,
gaurav, suppose my server has base memory of 4.5gb can i then use awe and set the maxmemory for the sql to use 4.25gb and leave the rest to os. is...
Thanks Very much!
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...
jasper_smith We are on sqlserver2000 so you say i should look at logical fragmentation Thanks for ur help
jasper, that link is of great help we have databases that contain one datafile and logfile in that case should i consider scan density these two...
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...
No jobs's were running at that time but they might be some transations going from different databases.At that time i didn't see any active...
when i run sp_who2 active but it is showing only that spid 03 is blocking spid 01, i am not clear what jobs have to do here sorry i am bad in...
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.
