December 2, 2013 at 1:06 pm
Hi,
what is the best way to monitor datafile and lofile grow ?
With custom scripts ?
Does perfmon can do that ?
regards
C
December 3, 2013 at 2:36 am
Hi,
you can use sql scripts from dbWarden. Here you got an email if there is an autogrowth on your database.
Or you can configure alerts in the SSMS.
December 3, 2013 at 3:21 am
There are built in utilities that let you monitor drive space on the system. Here's an example[/url] on how to use it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2013 at 12:51 pm
Hi,
do you have scripts examples of configure alerts in the SSMS ?
thanks !
December 3, 2013 at 11:52 pm
Hi,
here is a link how to create alerts.
http://technet.microsoft.com/en-us/library/ms366332.aspx
If you had created them, you can script them yourself. It is very easy
Andreas
December 6, 2013 at 4:03 am
I wrote this:
USE [Monitor]
GO
/****** Object: StoredProcedure [dbo].[sp_DBSizing] Script Date: 12/06/2013 12:01:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[sp_DBSizing]
as
begin transaction;
EXECUTE master.sys.sp_MSforeachdb
'USE [?];
insert into monitor.dbo.tbl_DBSizing
select CURRENT_TIMESTAMP
, d.name
, d.file_id
, d.size
, d.physical_name
from sys.database_files d
order by d.file_id, d.size;'
commit;
The information is logged to a holding table to be used in anticipating future storage requirements.
December 6, 2013 at 9:39 am
thanks for your script.
December 6, 2013 at 1:55 pm
Hi
You can use the performance monitor (perfmon.exe) by choosing "Log growths" and "Data file(s)" under the MSSQL$Instance:Databases for a specific database.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
December 13, 2013 at 10:23 am
Great !
Thanks for your answer !
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply