Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Log space issue Expand / Collapse
Author
Message
Posted Wednesday, October 23, 2013 10:36 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 8:15 AM
Points: 653, Visits: 1,428
I'd also recommend you take a look through "SQL Server Transaction Log Management" by Tony Davis and Gail Shaw.

You can obtain an electronic copy of the book from this site: http://www.sqlservercentral.com/articles/books/94938/

There's also a SQLServerCentral stairway on the topic: http://www.sqlservercentral.com/stairway/73776/

Together, that should provide you with everything you ever wanted to know about managing the SQL Server transaction log.
Post #1507740
Posted Wednesday, October 23, 2013 10:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
New persopn (10/23/2013)
Please advise me how can i take action here to reduce the log


Have you monitored the used space in the log over the course of several days? If so, what's the maximum size that the used portion of the log reaches?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1507749
Posted Thursday, October 24, 2013 7:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
yes i am monitor the log from last five days the maximum size of log used is : 7.03167
Post #1508043
Posted Thursday, October 24, 2013 7:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
How often were you monitoring?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1508044
Posted Thursday, October 24, 2013 8:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
i have created one job and it will run for every 15 mins and insert the results in to one table. here we have last four days data in that table
Post #1508077
Posted Monday, October 28, 2013 11:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
For one week i have monitored the log in weekends it is occupying 25% space so can anyone please update me on this.
Post #1509050
Posted Thursday, October 31, 2013 2:24 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:05 PM
Points: 33,165, Visits: 15,299
New persopn (10/28/2013)
For one week i have monitored the log in weekends it is occupying 25% space so can anyone please update me on this.


That sentence makes no sense.

If you found a max of 7GB, I'd probably shrink the log to 10GB. However, make sure that the max is in fact the max with all normal maintenance and workload operations inside the times you've monitored.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1510422
Posted Thursday, October 31, 2013 10:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
Thanks for your information.

How can i monitor the complete log usage in that particular time.
Post #1510492
Posted Friday, November 1, 2013 1:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:26 AM
Points: 2,840, Visits: 3,963
New persopn (10/31/2013)
How can i monitor the complete log usage in that particular time.

As steve mentioned above.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1510520
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse