No announcements
Found 615019 threads
-
2 VotesAlert-LOG Db Growth for BizTalkMgmtDb2010
Both way it will work ,generally SQL server Admin gives auto growth of SQL server files (MDF LDF) on percentage basis or keep it default at 10 % growth .Answered | 3 Replies | 698 Views | Created by Vivek.10 - Wednesday, November 19, 2014 3:14 PM | Last reply by Leonid Ganeline - Wednesday, November 19, 2014 11:15 PM
-
3 Votes
SQL log files growing unexpectedly.
You can control log file growth the same way you control data file growth.Answered | 8 Replies | 1287 Views | Created by kimdav111 - Monday, July 18, 2016 2:24 PM | Last reply by Customessaywritingservice - Tuesday, July 19, 2016 7:27 AM -
0 Votes
Alert for TempDB Growth
Select the "TempDB" Database you want to alert after past a specified threshold and click "health explorer".Answered | 1 Replies | 5632 Views | Created by P3OPLESH3RO - Monday, May 17, 2010 12:34 PM | Last reply by Paulo J. Mendes - Monday, May 17, 2010 1:03 PM -
0 Votes
DB Growth monitoring
[dbid] = db.Answered | 4 Replies | 1399 Views | Created by bogg06527 - Tuesday, January 19, 2016 12:38 PM | Last reply by Olaf Helper - Tuesday, January 19, 2016 12:46 PM -
0 Votes
OperationsManager db log file growth settings
How can I tell how much of the log file is actually being used?Answered | 4 Replies | 3318 Views | Created by tpullins - Tuesday, October 18, 2011 6:04 PM | Last reply by Michael Pearson - Tuesday, October 18, 2011 9:22 PM -
1 Votes
How to monitor the growth of DB
There are two primary ways to monitor the size/growth of your azure SQL Database.Answered | 2 Replies | 961 Views | Created by Krishna_msdn - Thursday, January 29, 2015 12:28 PM | Last reply by Krishna_msdn - Friday, January 30, 2015 2:03 PM -
0 Votes
SQL DB Growth
You will have to create a table and once a day insert into current size of all dbs + date of inserting.Answered | 1 Replies | 5309 Views | Created by VijayKSQL - Wednesday, January 5, 2011 10:26 AM | Last reply by Uri Dimant - Wednesday, January 5, 2011 10:43 AM -
0 Votes
DB Growth script
https://www.mssqltips.com/sqlservertip/3690/identify-sql-server-database-growth-rates/ https://www.datanumen.com/blogs/monitor-sql-server-database-g ...Answered | 2 Replies | 2487 Views | Created by Pradeepanand_DBA - Wednesday, January 3, 2018 9:56 AM | Last reply by Visakh16 - Wednesday, January 3, 2018 10:06 AM -
1 Votes
Disable Transaction Log growth.
SQL Server should have an option to turn logging off.Answered | 5 Replies | 9140 Views | Created by -VB- - Monday, October 18, 2010 8:13 AM | Last reply by Corby Nichols - Wednesday, December 28, 2011 8:18 PM -
2 Votes
Alert for database growth
Thanks Kevin, You solved my problem, instead of alert I have scheduled a job using your query which will work like alert for single database But ...Answered | 9 Replies | 3394 Views | Created by Mayur-DEW - Wednesday, August 22, 2012 11:02 AM | Last reply by Mayur-DEW - Friday, August 24, 2012 9:16 AM -
0 Votes
Can't get DB Log file to stay at unrestricted growth.
So you mean you are unable to change auto growth settings ?Answered | 5 Replies | 1402 Views | Created by Eatonjb - Thursday, July 23, 2015 5:53 PM | Last reply by Jinu Varghese - Friday, July 24, 2015 4:07 PM -
0 Votes
DB Shrink and Auto Growth Features
DB shrink is a feature which you should NEVER use unless you have grave requirement for space because it causes massive logical fragmentation and would seriously slow down your queries and ...Answered | 3 Replies | 1046 Views | Created by Shailendra Dev - Thursday, July 9, 2015 10:20 AM | Last reply by Shanky_621 - Friday, July 10, 2015 5:05 AM -
0 Votes
Alert when #of auto growth of datafile is less
for the same issue : Wscript.Sleep(600000) Script 2 :Create a WMI Alert EXEC msdb.dbo.sp_add_alert @name=N'Respond to Low ...Answered | 3 Replies | 5997 Views | Created by XYZ001 - Monday, April 25, 2011 10:39 PM | Last reply by Abhay_78 - Tuesday, April 26, 2011 6:56 AM -
5 Votes
Database log file growth
TableC - Another table from different server, we have implemented Linked server between two servers (Data will be loading from TableA using insert ...Answered | 7 Replies | 7390 Views | Created by Chreddy S - Monday, September 12, 2011 10:33 AM | Last reply by srivatsanraju - Friday, September 30, 2011 6:32 AM -
0 Votes
How to estimate log growth when providing DML
Hi , It is difficult to actually estimate the , Log file growth as it depends on various factors including recovery interval in simple recovery model.Answered | 4 Replies | 2316 Views | Created by volyn - Friday, November 16, 2012 9:08 AM | Last reply by Rama Udaya - Thursday, November 22, 2012 12:52 PM -
0 Votes
DB Transaction Log Alert Triggered Multiple Times
You can configure alert delays.Answered | 4 Replies | 4951 Views | Created by sams371 - Friday, February 24, 2012 3:03 AM | Last reply by sams371 - Sunday, February 26, 2012 6:33 PM -
4 Votes
SQL Log File Growth rate
Hi Humm, Seems that the log file growth rate of the database in B environment is set in %.Answered | 12 Replies | 1925 Views | Created by '''HuuM''' - Monday, December 2, 2013 3:27 PM | Last reply by Alankar Chakravorty - Monday, December 9, 2013 6:16 AM -
0 Votes
growth rate of DB
Hi, About how to find out the growth rate of DATABASE in MB for a particular month, please review Shanky’s and Uri’s posts.Answered | 3 Replies | 1115 Views | Created by venkat83 - Friday, July 25, 2014 7:19 PM | Last reply by Lydia Zhang - Tuesday, July 29, 2014 7:32 AM -
1 Votes
Log file Growth query
In SQL Server, a log file specified with unlimited growth has a maximum size of 2 TB, and a data file has a maximum size of 16 TB.Answered | 5 Replies | 4159 Views | Created by Ven Raja - Tuesday, June 11, 2013 4:58 PM | Last reply by SoHelpMeCodd - Wednesday, September 3, 2014 7:03 PM -
0 Votes
Abnormal TRN log growth while DBs are in SIMPLE recovery mode
" To the best of my knowledge, there is no improvement in the bulk-logged recovery model compared to simple recovery model regarding log growth.Answered | 14 Replies | 1091 Views | Created by Mahesh Dasari - Wednesday, February 1, 2017 12:20 AM | Last reply by Mahesh Dasari - Thursday, February 2, 2017 5:49 PM - Items 1 to 20 of 615019 Next ›
No announcements
