Viewing 15 posts - 211 through 225 (of 337 total)
GilaMonster (3/25/2011)
SQL writes data modifications to data pages in the data cache. It writes the log records to disk at the point the transaction is committed (or sometimes before). At...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 27, 2011 at 11:10 am
If I understand this correctly let me get this right in terms of cookie analogy.
The cookie plate is your physical log file.
The good cookies are your inactive VLF.
The bad cookies...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 23, 2011 at 7:52 am
Thanks for the link muthukkumaran
Following is the extract from your blog which is your definition of truncation of log
SQL server run the CHECKPOINT truncates the inactive portion of the log...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 23, 2011 at 4:33 am
Brandie Tarvin (3/22/2011)
You're welcome. I hope the analogy made things easier to understand for you.
Yes it was perfect.
Now I am much more clearer on the basics of log files than...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:49 pm
GilaMonster (3/22/2011)
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Thanks for the link.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:44 pm
You are misreading that entry. It says it truncates, not shrinks. Truncate allows SQL to reuse the portion of the log that was just freed. It's like eating the cookies...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:38 pm
Brandie Tarvin (3/22/2011)
A checkpoint doesn't change the size of the log files. It just marks a section of the log as ready to be reused by the transaction log process....
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:29 pm
Ok Ok Ok.Now I got it.
Sorry for getting this all mixed up.I was expecting the same behavior both on log and the datafiles when shrinking with these 2 options.
One last...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:22 pm
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
So when a checkpoint occurs the...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:11 pm
Ok now I understood.
I thought that truncateonly when used with shrink command for log files releases the inactive VLF's which are at the end of the log file to the...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 12:03 pm
Hey Brandie,
I do agree that changing from FULL to SIMPLE will break the log chain but just wanted to highlight the fact that OP had mentioned that his/her recovery model...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 11:44 am
Yes sorry I should had rephrased my statement to "TruncateOnly no longer supported with log backups'.
But with the definitions you provided does not seem to be exactly doing the same...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 11:29 am
muthukkumaran (3/22/2011)
mail.pnreddy (3/21/2011)
Here are the steps i followed.
Change the DB back to Simple If it is in Full mode.
Change it back to Full mode.
Use T-sql...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 22, 2011 at 11:06 am
GilaMonster (3/20/2011)
Marios Philippopoulos (3/19/2011)
Can you elaborate on the latter two? "table parameters or cached temp table shells".
For table-type parameters see Books Online.
Since 2005 SQL can cache temp tables that are...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 21, 2011 at 5:16 am
Well it depends on the workload on the server.
The buffer pool will always remains in the range of Min and Max memory setting value and will not be paged out...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 15, 2011 at 12:35 pm
Viewing 15 posts - 211 through 225 (of 337 total)