473,378 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Spacing problem in SQL Server

Consider a scenario, I am a DBA for the Database server where the
size of the hard disk is 100 GB. On that database server, i have the
Database whose size is 40 GB. Also, i restrict the size of the
database file to 95 GB, by specifying the "maximum file size" to
"Restrict file growth" option , under the "file properties".

I then copied a DAT ( or some other file ) on the same database server
that is having the size of 45 GB.

Now when the Database file size increases, it will give an error not
because of setting the "Restrict file growth" option to 95 but there
is no space on the Hard Disk.

My question to you DBAs is that, how will i know that hard disk is
becoming full ? I want to get noticed when the Server's Hard Disk size
is at some specified threshold value.

Pls help in this regard.
Jul 20 '05 #1
1 2838

"Prashant Thakwani" <th******@rediffmail.com> wrote in message
news:bf*************************@posting.google.co m...
Consider a scenario, I am a DBA for the Database server where the
size of the hard disk is 100 GB. On that database server, i have the
Database whose size is 40 GB. Also, i restrict the size of the
database file to 95 GB, by specifying the "maximum file size" to
"Restrict file growth" option , under the "file properties".

I then copied a DAT ( or some other file ) on the same database server
that is having the size of 45 GB.

Now when the Database file size increases, it will give an error not
because of setting the "Restrict file growth" option to 95 but there
is no space on the Hard Disk.

My question to you DBAs is that, how will i know that hard disk is
becoming full ? I want to get noticed when the Server's Hard Disk size
is at some specified threshold value.

Pls help in this regard.


There are (at least) two general options - address this as a generic systems
issue, or as a specific MSSQL issue. If you look at it as a systems issue,
you can use any monitoring tool which tracks disk usage, or you can set an
Alert on the LogicalDisk:Free Megabytes counter using Perfmon. You might
already have a tool in your organization that can do this, or you could
create a generic Perl/VB/VBScript etc. script to do it.

Alternatively, if you need to provide your own solution specific to MSSQL,
you could use xp_cmdshell and/or xp_fixeddrives to get the free space on the
drive, then do something (note - xp_fixeddrives is not documented, so it
would probably be a bad idea to rely on it). Personally, I would prefer the
first solution, as it is more generic, you can reuse it for non-MSSQL
servers, and getting OS-level information is often easier outside the
database.

Simon
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Hal Vaughan | last post by:
I'm testing a GUI app on a couple Linux boxen and one Win2k box. I'm using Java 1.4.2 on each (or the closest on Win2k -- whatever version comes close). On one Linux box and the Win2k box the...
12
by: Rick DeBay | last post by:
I'm trying to create a layout table, where the spacing between rows varies. I've tried using setting margin-top and border-top for the rows I wan't spaced down from the one above, and I've also...
2
by: Gnolen | last post by:
Hi again, Last time my server was down(as for many others I have heard), but now it is online again! I would be really really happy if someone could take a look at my problem a bit. I now...
4
by: fleemo17 | last post by:
Is there a way to tweak the spacing of lines of text (or leading) *specifically* in IE6? I've created a "Quick Search" box in my layout which renders pretty consistently in all the browsers I've...
12
by: Sebastien B. | last post by:
I'm wondering if it's at all possible to have spacing between a table's cells, and only between the cells, not between the outter cells and the table's border. See end of message for an example...
2
by: Greg Linwood | last post by:
I'm using a Data Grid and want to apply wider spacing between columns than rows. As such, cellspacing / padding aren't any use to me. I used to do this in html tables by simply adding columns...
5
by: Goldy | last post by:
Hello, w/ code like this: <table border="0" cellspacing="0" cellpadding="0"> <asp:Repeater runat="server" id="op"> <HeaderTemplate></HeaderTemplate> <ItemTemplate> <tr> <td...
4
by: metoikos | last post by:
I've scoured the web (clumsily, I'm sure) for information on the difficulties I am having, checked my markup in validators, and had a friend with more CSS clue look over it, but I haven't had any...
10
by: phil-news-nospam | last post by:
I have a table with 3 columns in 1 row. I want to increase the spacing _between_ the columns (gutter) _without_ increasing the spacing between those columns and the table itself. Is there a way...
1
by: replyrpatil | last post by:
What I am trying to do: I need to print a compact access report (font 6 size) created using RTF2 program developed by Stephen Lebans to generate a TIF image of custom size (5.5 in x 2.0 in) ...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.