.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQl Transaciton log growth

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server

I am using a thrid party software to replicate the SQL Database . My SQL Administrator complains that ever since we started using that , the transactions logs are getting bigger, I can not agree with that statement as this software uses a filter driver and just sit above the file system, it should not make any changes to the sql database


Which all counters or tools available to monitor the sql Transaciton log, Please advise




View Complete Post

More Related Resource Links

Log file growth on SQL Server logshiping

Hello, We have a server, on which a database is setup for logshipping for reporting on the secondary server.The log backup is set up for every 15 minutes.The whole process is running sucessfully.My question: why does the log file grows even after the log backup is done every 15 minutes.we have seen the log file grows bigger and bigger? Is this a valid scenario?What should we do to avoid this? Sql 2k5 enterprise on Win 2003. RegardsVenkat

Report with Static Layout (Restrict Rectangle Growth/Static Tablix size)

How do you stop a Tablix or the rectangle that is a Tablix is contained in from growing.  I have been designing a report that must have a very specific layout due to government and commericial policies.  In this report is a header on top, a footer, some other reporting data above and below a rectangle that contains a tablix region.  I need this tablix and/or rectange to stay a constant size, if there are more rows, it should start another page in the report.  Instead, it grows and pushes all the datafields below it, down and off the page.    I have also tried this with a frame.  The table must show within the frame on form only.  The frame can contain maximum of 10 rows, but the table will grow outside the frame and the items below are pushed down and off the page.  I cannot see how I can setup a page break on every 10th row on a table. Does anyone know how setup a constant size Tablix/Table in a rectangle or frame so that it will not grow beyond the specified size (so the data fields below it will not be moved) and will instead create a new page?  This is crucial to our application and we may have to switch reporting solutions if we can get this figured out. Thanks for you help!  

SSRS 2008 Matrix - Cannot get average formula or growth formula to work

I have a report in Excel that I'm trying to replicate in SSRS 2008.  The report looks like this:   Priority 08/21/10 08/14/10 08/07/10 07/31/10 07/24/10 07/17/10 07/10/10 TOTAL Average Customer Name Code # of Lds # of Lds # of Lds # of Lds # of Lds # of Lds # of Lds  # of Lds   Check  #N/A            4            4            4            8            4            9           -            33          5       83%  A2             1          -            -            -            -            -           

Expansion from an Active/Passive SQL 2008 setup to ... ? (Supporting our growth)

Hi. I'm a sysadmin (or rather Jack of all trades) that also takes care of a MS SQL 2008 (standard) servercluster that is in an Active/Passive setup (2 servers, one active, one standby with files stored on a SAN with dual 10Gbps connection). We are currently hitting the limits of what a single SQL server (on our hardware) can handle. We are growing and our clients are as well. As such, we're starting to see slow-downs on SQL level (a part due to application design, but part simply due to capacity). I've been doing my best to read up on all options, where we can increase performance , yet maintain our current failover capacity . An ideal scenario would be to just make both nodes 'Active' and allow querying on both while their databases remain sync'ed in the event one of them were to fail. There is however no such thing as an "Active/Active" MS SQL 2008 cluster. I've been reading more and more about (Transactional) Replication, Mirroring, Log Shipping and so on, but either it does not really fit to our current situation, or it would require more hardware than I have at my disposal. I'm afraid I don't fully comprehend all the implications of the available technologies. Am I overlooking something? What solution would you suggest? The new setup must be capable of automatically failovering with no (or extremely minimal ) dataloss , yet get better performanc

Very high transaction log file growth in SQL server

Hi,   I am using with below version of SQL server. Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2).   One of my database transaction log file is getting full very frequently on PROD database,which i have truncated ones and shrunk ones after that i have taken full backup immediately.Again the Db tran log file grown to very big size. We are taking the transaction log backup for evry one hour. and The column shows log_reuse_wait=2 & log_reuse_wait_desc=LOG_BACKUP from sys.databases. Can you please suggest me free the transaction log space without truncating the log file.   Thanks, Gangadhar  

transaction log growth control


For better control our production log growth, I come up with the following tentative plan:

Set upper limit for log file size, say 10GB;

make backup log on a regular basis by a SQL Server job, say once per 7 or 3/4 days;

since there is guarantee that real log space never increases 5GB in 7days in our environment, and each backup log operation makes inactive virtual logs reusable.

This plan may work well for constraining our trans log within 10GB.

Comments, pros and cons, advice/suggestions?

BTW, any way to find out how many virtual log files are there, and active or inactive, and for SQL Server 2000 and 2008?

Hyper-V R2 VHD Growth with Sharepoint 2010


I'm having some trouble with my Sharepoint 2010 Hyper-V VHD. It continues to grow and grow until the host server runs out of disk space. Once the server is rebooted, the space recycles and doesn't grow for some time, but it always starts to grow again and fills up the host. Some info on my environment:


The Sharepoint 2010 VHD is set to dynamically grow, and the max size is 1TB. (I have set all my VHDs to this size, and haven't had this problem with any other virtual server.) I set it to this size so that even if the physical hardware runs out of space, the virtual server won't. 

It's currently running on a server that has 250GB hard drives. While I know this is significantly smaller than the 1TB VHD, some of our hardware has larger hard drives, and virts tend to get migrated around as need be. 

All databases have been set to simple, and none of them are expanding at a rate that would cause this issue. 


Like I said above, we run mostly everything in virts, and all of the virts are setup the same way, dynamically expanding with 1TB VHDs. NONE of them act this way. My question is, what is filling up my VHD? Is it Sharepoint doing something or is it something else? 


Thanks. -Jim

index rebuild (offline) on sql 2005 sp3 enterprise causes drastics growth of the database size(mdf)


index rebuild (offline) on sql 2005 sp3 enterprise causes drastics growth of the database size(mdf)

database grew from 40 GB to 500 GB. space is reserved no free space to reclaim after reindex completes.

pls guide

MS SQL Express 2005 unexpected dtatabase growth troubleshoointg


We use an application that is using MS SQL Express 2005 as its database back-end (as seems to be the case with pretty much everything any more). We ran the application for many years, without issues and experienced a growth of about 200mb/year. Everything ran like this fine until 2007. Between 2007 and 2008 my database quadrupled in size:

database.dat 625mb

database.dat 789mb

2008YE (should note here, that the database jumped in size during the year end - the year end for 2007 was ~800mb - the beginning of 2008 was where I noticed the ~3,000mb jump)
database.dat 3,350mb

database.dat 5,236mb

databse.dat 5,732mb

No one noticed a difference in the application (that I am aware of), instead they just began accommodating that size of a system by purchasing larger storage facility and higher end backup procedures.

I guess my question is, does this seem normal? Is there anything I can do to try and troubleshoot it and determine the actual size the database should be? We have a sister company that is running the same application, and the data base on that side of the house has consistently ran about 200mb/year with out the large jump. When I questioned the

i have no idea on charts and i have an requirement of child growth charts pls any help


i have no idea on charts and i have an requirement of child growth charts pls any help

am using visual studio 2008, how to get a chart control and how to use it and

any examples for growth charts

thank u

Disable Transaction Log growth.



it is possible to turn off Transaction Log growth in SQL Server 2008 R2? The problem is that we have low disk space. And i need Load big table, which have a lot of columns and almost on all are indexes. So load is failing because of transaction Log. O set recovery model to Simple.

I think only about one solution.


1) Drop all indexes on destination table.

2) Load data to table.

3) Recreate indexes.


I noticed, that when i load data to table which hasn't any indexes transaction log isn't growing.

Any other ideas?

Rapid Content DB Growth

Starting last Thursday a content db we are using on one of our site collections started to grow very rapidly. It was increasing in size by 256MB at a time. From midnight 1am until about noon yesterday it went up by 13GB and the log is increasing dramatically as well. From 4:31am until 4:33 there were 13 hits and the size increased by 3.25GB, 256MB at a time. I am running a little util I created that logs any changes  to libraries and lists from a specific date or time. The scan is about 1/2 done. I can see lots of updates and additions, just nothing that could account for such a large increase so quickly. Anyone have any idea what could be causing this?

SharePoint 2010 content growth AFTER migration



After upgarding our SP 2007 instance to 2010, our main content db has mysteriously grown to almost double the original size.

Has anyone experienced this and is this due anything particular or flaw in the upgrade process?

verify tempdb growth


My tempdb was set at 30,000MB for Data and 7,500MB for Log, and both set to Autogrowth by 10% unrestricted. I have a suspicion that my tempdb grew significantly yesterday because when I do sp_helpdb 'tempdb' today, I get approx 40,000MB for Data and 100,000MB for Log.

Now, it is possible that the log file (.ldf) had been growing steadly all along, until it reached its current size of 100,000MB but the reason why I suspect it grew suddenly between yesterday and today is because the disk utilization is much higher than it was yesterday.

Now, I do know a little about tempdb which is that it is used by SQL Server to do it internal work and if there was a lot of stuff going on, it can increase the size of the tempdb. Is there a way for me to find out after the fact (no trace was running to specifically look for db growth) what exactly happened?

WMIEventProviderNotificationQueue excesive growth when auditing through SMO




I wrote an application to monitor Logins and Logouts in SQL 2008 but in some servers the WMIEventProviderNotificationQueue is growing without an apparent cause. I have read some documentation regarding this queue but none have help me figure out why the growth or how to clear it up. Can some one point me in the right direction?


Monitoring Table Size Growth in SQL Server

n this article I introduce a simple process that saves tables size information at points in time which latter allows for tracking down table growth over time.

The process is useful in monitoring data growth over time and lets you see what tables are growing rapidly in what databases and can also help in estimating future growth and disk space requirements. In addition it can help prevent unexpectedly running out of disk space, or if you are already in that situation then quickly find the table(s) that for some reason have grown more than excepted and are the source to the problem.

I addition, I also show a stored procedure called sp_DataFiles that returns a report of disk space usage information at the data file level.

Is there any script for daily how much my database growth rate increasing




s there any script for daily how much my database growth rate increasing


Plz tel me any advice hw can we trac growth rate of DB for daily basis

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend