Hello,
I need to monitor every 15 minutes growth in data file and log file .
Since mdf and intial file sizes are set to high value,
measuring these values at 15 min interval will not provide the change
in size .
My intention is to measure the log file size growth which helps to
calculate the disk space and bandwidth required to setup log shipping .
We need to set up this infrastructure based on this calculation
Thanks
M A Srinivas 6 5131
I found that on Google and added some further stuff like ID and
Reporting Date in order to keep the information stored permantly, for
permanent storage of the table create a non-temporary one.:
create table #dbinfo
(
ReportId INT IDENTITY(1,1),
dbname sysname,
dbsize decimal(10,2),
dbused decimal(10,2),
ReportDate datetime DEFAULT GETDATE()
)
exec sp_MSforeachdb 'insert into #dbinfo(dbname, dbsize, dbused) select
''?'', dbsize = sum(convert(dec(15),size))/128, (select
sum(convert(dec(15),used))/128 from [?]..sysindexes where indid in (0,
1,
255)) from [?].dbo.sysfiles where status & 0x40 = 0'
Select * from #dbinfo
I executed the query at different time intervals and found that dbsize
is not changing.
What I basically requires to know the size of the log file ( every 15
mins) without actually implementing log shipping . Is this possible ?
Thanks
Srinivas
Query gives the same database size at different intervals , even though
activity has occured on the database.
What I require is to find the size of log file ( every 15 mins )
without actually implementing Log shipping. I need to set up a script
in production server and measure the log size (every 15 mins ) and Log
shipping set up is not allowed at this point of time .
Thanks
Srinivas
Unless the file expands the size won't change
When you have autogrow of 10 percent and you fill up only 8 percent the
file size won't change until it hits that threshold http://sqlservercode.blogspot.com/ ma******@gmail.com wrote: Query gives the same database size at different intervals , even though activity has occured on the database.
What I require is to find the size of log file ( every 15 mins ) without actually implementing Log shipping. I need to set up a script in production server and measure the log size (every 15 mins ) and Log shipping set up is not allowed at this point of time .
Thanks
Srinivas
(ma******@gmail.com) writes: Query gives the same database size at different intervals , even though activity has occured on the database.
What I require is to find the size of log file ( every 15 mins ) without actually implementing Log shipping. I need to set up a script in production server and measure the log size (every 15 mins ) and Log shipping set up is not allowed at this point of time .
What do you want to know? The size of the log file, or the size of
the transaction log actually in use? The log file only increases in
size when it has to.
For the current log size, DBCC SQLPERF may be an alternative.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Having just recently begun to g othrough log shipping processes myselg,
I think I understand what you're asking: you want to know how big will
the individual log files be (on average) during the log shipping
process, correct? You don't have to actually ship these files to find
out, but you will need to implement a transaction log plan that backs
up your transaction log every 15 minutes.
Use the Maintenance Plan wizard, and without implementing log shipping,
set up a plan that backs up your transaction logs. This can be safely
implemented on a production server, assuming that you don't already
have a backup plan in place that relies on transaction logs for
point-in-time restoration; if you do, then you should already have
method of answering this question. :)
Be sure that your database recovery mode is set to FULL.
HTH,
Stu This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Nabhonil Sinha |
last post by:
hi,
There is facility to do backup of the database. I can use that
facility to backup the database. But before i do a backup i want to
check if the disk space available enough to backup that...
|
by: gurdipv |
last post by:
Hello,
I recently deleted the directory
C:\Program Files\Microsoft SQL Server\MSSQL\Data
On my production database server.
I managed using undelete software to get back most of the LDF/MDF...
|
by: micky |
last post by:
there are three wesite called A,B,C
these are just share 1 database file called database.mdf in app_data
it's that i wanna make design. i don't want to use sql server machine. just
use...
|
by: Arne |
last post by:
How do I create aspnet.mdf on a production machine?
How do I administer users on a production machine?
|
by: Goofy |
last post by:
The add database ( MDF ) in Visual Studio 2005 seems to be in SQL Server
2005 format as far as I can tell. Does anyone know how I can import tables
( without having to start writing queries ) from...
|
by: Goofy |
last post by:
The add database ( MDF ) in Visual Studio 2005 seems to be in SQL Server
2005 format as far as I can tell. Does anyone know how I can import tables
( without having to start writing queries ) from...
|
by: sal21 |
last post by:
admit i have a sql in c:\scrpit\myscript\database.mdf how to Attache (or register) in one instance of my sql server?
All in vb classic, tks.
|
by: leonaisse |
last post by:
Hi
I have a bunch on tables and data in my local SQL Server 2005 Express master
DB and I want to export it to a database.mdf within my wwwroot (visual
studio) file - how can i do this?
Thanks...
|
by: Bassem |
last post by:
Sorry for the basic question, but I searched much and got nothing.
A C#, SQLServer 2005 database (*.mdf) using SqlClient what I got here.
What do I need to delver this software to an end user,...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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...
|
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
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
| |