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 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
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...
I have a question in the active/active scenario
If node1 fails it failsover to node2 then the node will be...
You understood the question correct is that the same in active/active
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
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
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.
Thanks Very much!
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...
We are on sqlserver2000 so you say i should look
at logical fragmentation
Thanks for ur help
that link is of great help
we have databases that contain one datafile and logfile
in that case should i consider scan density
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.