Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2011

TransactionLog Internals

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file for every database, >> Transaction log is always write in sequential manner , Only at redo state … Continue reading

Read more

0 comments, 343 reads

Posted in Vinay Thakur on 22 June 2011

Difference between Checkpoint and LazyWriter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk 1. Flush dirty pages to disk. 2. Flush only Data pages to disk 2. Check for available memory and removed … Continue reading

Read more

0 comments, 672 reads

Posted in Vinay Thakur on 20 June 2011

Difference between Checkpoint and LazyWritter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk 1. Flush dirty pages to disk. 2. Flush only Data pages to disk 2. Check for available memory and removed … Continue reading

Read more

0 comments, 224 reads

Posted in Vinay Thakur on 20 June 2011

How Query execute

*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from disk(file). Select : The command will go to relational engine and create a query plan for the same. –compile plan … Continue reading

Read more

0 comments, 194 reads

Posted in Vinay Thakur on 10 June 2011

Isolation level and Locks

Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends on isoalition level the level of isolation are as 1. Uncommitted Read (NoLock) 2. Committed Read (blocking) 3. Repeatable Read (phantom) … Continue reading

Read more

0 comments, 459 reads

Posted in Vinay Thakur on 8 June 2011

Failure Cluster -General

We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”) and realized that I have not blog much about clustering, Here I will be considering 2 node clustering “Active -Passive” … Continue reading

Read more

0 comments, 263 reads

Posted in Vinay Thakur on 4 June 2011