Hi Grant
I tried the script on another test server with 16GB of RAM but kept the max server memory as the default value and i used the split...

Hi Thom
I am asking the systems team to increase the RAM and see what happens but what is happening is as follows
I have a table with...

Just an update i already have an index on the column ID as a non-clustered index

USE [DB]
GO
CREATE NONCLUSTERED INDEX [NCI_MEMOPOOL]
ON [dbo].[MEMOPOOL_DATA] ([ID])

GO

Could...

Dear Thom
The server has 4GB of memory and i placed max memory as 3GB
There is no index on the column i will create an index on that...

Ok say that I did have it inserted as N'Japanese characters' and I do a select and question marks are returned. Then how do I make the data readable without...

Thanks guys I appreciate the help and keep up the great work

Have a good week

Kal

Hi Gail

This is the script i am using and i did include checkpoint and now its showing up as NOTHING

Its ok to include it right?

Also the following script...

I figured out my issue

I was running checkpoint while using another database than the one in the script

So when running the scripts if i include

CHECKPOINT

GO

And...

Ok i will inform my management and see what i can do as they are now thinking of putting the recovery mode as simple

But i tried to run the...

I stand corrected

The transaction log backup sizes vary from

85K to 150MB

The biggest one was this morning at 6am at 11gb but after that the sizes vary from 4MB...

The hourly transaction logs vary in size from 4mb to now it's 12GB

The size went up to 12GB from 2gb in one night as indexing and crawling were enabled...

Nope

It seems something is not updating the column again so i ask all the experts again.

What would cause the value log_reuse_wait_desc to not update?

I am not running mirroring...

I have tested this on both SQL Server 2008 and 2012 and the value isnt updating from LOG_BACKUP to NOTHING

What could be holding onto this value in both my databases?...

And is there a way to mark the VLFs manually for reuse?

i thought maybe the script i was using wasnt signaling the Database to update the column value in...