|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
Archives: June 2011
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
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
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
*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
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
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
|
Subscribe to this blog
