<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Waring alters when the database (files MDF,...
13 posts, Page 1 of 2
1
2
»»
Waring alters when the database (files MDF, NDF & LDF) reaching the MAX size.
Rate Topic
Display Mode
Topic Options
Author
Message
Ranzz
Ranzz
Posted Friday, February 15, 2013 5:29 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 29, 2013 9:26 AM
Points: 138,
Visits: 511
HI Frnds,
I need help on setting up alters when the database (files MDF, NDF & LDF) reaching the MAX size.
If anybody have some thing please share, I am trying to lookup in google and I didnt get anything.
If anybody have good post on how to implement it please post it.
Thanks in advance.
Post #1420834
SQLAJ
SQLAJ
Posted Saturday, February 16, 2013 6:35 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:21 AM
Points: 85,
Visits: 361
Ranzz (2/15/2013)
HI Frnds,
I need help on setting up alters when the database (files MDF, NDF & LDF) reaching the MAX size.
If anybody have some thing please share, I am trying to lookup in google and I didnt get anything.
If anybody have good post on how to implement it please post it.
Thanks in advance.
What do you mean by "setting up alters"? Do you mean "alerts" when the files are nearing max size?
Or when the free space on the drive is getting low?
______________________________
AJ Mendo | @SQLAJ
Post #1420888
MyDoggieJessie
MyDoggieJessie
Posted Saturday, February 16, 2013 11:01 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 2,063,
Visits: 3,788
You can set up alerts under the SQL Server agent, I believe the type is "SQL Server Performance Condition Alert" and it will allow you to set thresholds for each database. I can't remember if the value counter allows a percentage or if it needs to be a literal value. You should be able to find that out in BOL
______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1420907
Ranzz
Ranzz
Posted Saturday, February 16, 2013 2:26 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 29, 2013 9:26 AM
Points: 138,
Visits: 511
Thanks SQLAJ
yes i mean by alerts..sorry misspelled.
when the files are nearing max sizes. how to implement it.
If there is any good blog post, how to set up please forward it.
thanks.
Post #1420933
SQLAJ
SQLAJ
Posted Sunday, February 17, 2013 7:37 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:21 AM
Points: 85,
Visits: 361
Ranzz,
Take a look at this post. It has some code you can use and shows some examples of alerts.
http://www.sqlmag.com/blog/practical-sql-server-45/sql-server-2012/disk-space-monitoring-143552
______________________________
AJ Mendo | @SQLAJ
Post #1420979
Ranzz
Ranzz
Posted Monday, February 18, 2013 9:31 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 29, 2013 9:26 AM
Points: 138,
Visits: 511
Good Post AQLAJ,
It give information on Drive Spaces at certain threshold.
But, I am looking at a threshold alerts when the database (files MDF & LDF) reaching the MAX size.
Please any help frnds..! Thanks in Advance.
Post #1421275
SQLAJ
SQLAJ
Posted Monday, February 18, 2013 11:10 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:21 AM
Points: 85,
Visits: 361
Use something like this script to monitor the size and free space of the files.
Setup a job that runs everyday/week insert into a database to monitor/track over time, send you an email or both.
SELECT
[name]
, [physical_name]
, CAST(([size] / 128.0) AS decimal(18,2)) AS FileSizeInMB
, CAST((fileproperty([name],'SpaceUsed')) / 128.0 AS decimal(18,2)) AS SpaceUsedInMB
, CAST((([size] - fileproperty([name],'SpaceUsed')) / 128.0) AS decimal(18,2)) AS FreeSpaceInMB
FROM sys.database_files
______________________________
AJ Mendo | @SQLAJ
Post #1421306
Ranzz
Ranzz
Posted Monday, February 18, 2013 12:45 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 29, 2013 9:26 AM
Points: 138,
Visits: 511
I am that confident on creating my own.
Can one please help me providing some documention how to implement it.
Post #1421329
ScottPletcher
ScottPletcher
Posted Monday, February 18, 2013 2:02 PM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 10:11 AM
Points: 1,333,
Visits: 1,803
Instead of constantly trying to adjust the max size, I'd suggest setting the max to "UNLIMITED", then monitoring and alerting for every file growth occurence instead.
SQL DBA,SQL Server MVP('07, '08, '09)
One man with courage makes a majority. Andrew Jackson
Post #1421348
Ranzz
Ranzz
Posted Monday, February 18, 2013 3:57 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 29, 2013 9:26 AM
Points: 138,
Visits: 511
It cant be possible to set unlimited growth.
So, that is the reason, I am looking for some thing that will help us.
Post #1421363
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
