max size of sqla 9 log file

Hi.  Yesterday, while remoted into a customer's server, I noticed their sql9 
log file was over a gig in size.
The server OS is w2k.  What is the maximum size that log file may reach? 
Does a log file that size affect performance?
This is a production instance and we are moving them to sqla 11 later this 
month, so I was reluctant to issue a backup-with-truncate command.
Any suggestions/thoughts appreciated.
Thanks,
Doug

0
Doug
1/6/2011 1:40:37 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

1 Replies
487 Views

Similar Articles

[PageSpeed] 22

 From the "limitations" section in the doc:
File size (FAT 32):  4 GB
File size for NTFS:
	256 GB for 1 KB pages
	512 GB for 2KB pages
	1 TB for 4 KB pages
	2 TB for 8 KB pages

A large log file does not generally affect performance. Backing it up 
will take more time and translating it to SQL statements (dbtran) will 
take more time but that's about it.

-john.

John Smirnios
Senior Staff Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere 
Developer Community at http://www.ianywhere.com/developer


On 1/6/2011 8:40 AM, Doug Stone wrote:
> Hi. Yesterday, while remoted into a customer's server, I noticed their
> sql9 log file was over a gig in size.
> The server OS is w2k. What is the maximum size that log file may reach?
> Does a log file that size affect performance?
> This is a production instance and we are moving them to sqla 11 later
> this month, so I was reluctant to issue a backup-with-truncate command.
> Any suggestions/thoughts appreciated.
> Thanks,
> Doug
>
0
John
1/6/2011 2:34:09 PM
Reply:

Similar Artilces:

Abend.log max file size
Does anyone know how to increase the max size of the abend.log file? I have 3 servers out of 30 that for some reason get to 100k and then won't write to the log file after that. I have no idea why those particular servers have restrictions and all the others don't, especially since I can't find anyplace to set the size of that file. Thanks. -- Rmurphy24 ------------------------------------------------------------------------ Rmurphy24;1565029 Wrote: > Does anyone know how to increase the max size of the abend.log file? I > have 3 servers out of 30 t...

Max Size of Transaction Log File
I try to limit the size of transaction log file. According to online help, -m option may speed up the database fragmentation when .log and .db files are on the same drive. Another approach is to create an event handler and use BACKUP DATABASE DIRECTORY '' ... command to truncate the log file when it exceeds certain size. Is there a third road to limit the log file growth? Any drawback on the second approach and what is a practical max size of the log file? Thanks. mason wrote: > I try to limit the size of transaction log file. According to online > help, -m op...

sqla max file size on 32 bit windows
What is the maximum sqla v9/10/11 db file size, when running on 32 bit windows? Thanks, Doug This will depend on the page size that you are using, and the filesystem that is being used to hold the database (files). The maximums have not changed between any of these versions. Take a look in the docs under: SQL Anywhere� Server - Database Administration Physical Limitations Size and number limitations -- Mark Culp SQLAnywhere Research and Development Sybase iAnywhere Engineering ------------------------------------------------------------------------- -- SQL A...

curious max user log cache size observation (11.9.2x)
Hi, I have a semi-interesting observation while reviewing multiple sp_sysmon runs on 11.9.2x. Typically when the ULC is flushed due to it being full, the "Max ULC Size During Sample" will match the "max user log cache size". As you can see below, there is a 4 byte discrepency between the two. Why should I care about 4 bytes? Normally, I don't but I've noticed that when they don't match, it is almost always 4 bytes difference (about 90% of the time with 8 bytes being the other times). Yes, yes, I know about the "remaining portion of the ...

curious max user log cache size observation (11.9.2x)
Hi, I have a semi-interesting observation while reviewing multiple sp_sysmon runs on 11.9.2x. Typically when the ULC is flushed due to it being full, the "Max ULC Size During Sample" will match the "max user log cache size". As you can see below, there is a 4 byte discrepency between the two. Why should I care about 4 bytes? Normally, I don't but I've noticed that when they don't match, it is almost always 4 bytes difference (about 90% of the time with 8 bytes being the other times). Yes, yes, I know about the "remaining portion of the ...

Log file size different for dbbacked up logs
ASA 6.0.3.2747 I noticed that the log files created by dbbackup are 8k, whereas the 'live' log files are 192k. Is this a problem? Most of these log files have no transactions -- they are the result of my testing replication using dbbackup etc. and I'm not creating any transactions between iterations. I haven't noticed any problems with the backed-up versions of the log files -- I can even run the remote agent against them. So really I am just looking for some reassurance that the 8k log files are OK. My command line is: DBBACKUP -r -k -y -t -c ...etc. Tha...

Max File size!
Does anyone know what the maximum file size is for a SQLAnywhere 5.0 database, running the 16-Bit engine on NT 4 server. The SQL books say 2G, they also state that if the engine is running on an NTFS partition that the limitation of file size is determined by the OS. Does this apply to the 16-Bit engine? Thanks in advance for your help. Eric Vinson Eric_Vinson wrote... > Does anyone know what the maximum file size is for a SQLAnywhere 5.0 > database, running the 16-Bit engine on NT 4 server. The SQL books say 2G, > they also state that if the engine is running on a...

LOG File Size
I am looking forward for the log file size where it will not take a performance hit. For example of about 30GB database, ENV ASA 5.5 and ASA 8.0.2 Thanks VSV To improve performance of the log file, make sure that it is hosted on a separate physical hard drive on the same machine that is hosting the server. If the log and the db are on the same device, they will compete for access to the read/write head of the drive. There are several options for log file management. I suggest that you look into the use of -r option of the dbbackup command. Its use will result in a backup an...

Log max size
is there a way to define a max size for the filter and junk logs? when the log gets on the X size, the older logs are deleted and the newer ones gets logged ...

Log file size
I was just browsing my SQL server and realized that my dotnetnuke database LOG file in SQL was almost 10 gig in size. Is there a way to disable logging in DotNetNuke? You can set the number of days for logging, I think default is 60? I believe it's under host settings, and can be per portal.ChrisHammond.comEngage Software What about archiving the info for tend analysis over a year for example. How about adding an archiving capability that exports just the log into a zip file for later retreival by a yet to be built module that can read the zip file. As we all know clients like to...

Log file sizes
We have post office agents running on both Netware and windows boxes. On the netware boxes log files are smaller and there many small files on a daily basis. On the windows boxes only a single file is created on a daily basis and this can be quite large and cumbersome to use. Is there anyway to choose the log file size on a windows box?? Also on a windows box we have trouble setting the physical log file allocation space. We set it with the switch /logmax-size option but it defaults to a different than we set. Also found to have trouble setting through consoleone. Anyone have ...

log file size
Should the log file created the first time you run discovery be growing to 20 gb? Are there settings you can change on what gets logged? This is a new 10.1 install. -- cleik ------------------------------------------------------------------------ cleik, >Should the log file created the first time you run discovery be growing >to 20 gb? Are there settings you can change on what gets logged? This >is a new 10.1 install. Component Name: Deployment Enable Debugging (self documenting xml file. Set to FINEST): Windows server: \Program Files\Novell\ZENworks\c...

Enforce max file size of 5MB with "File upload" control
Hi, Whenever I try to upload a file bigger than 4MB I get an "Internet Explorer cannot display the webpage" error.I googled on this and found out that the solution is to increase the value of maxRequestLength in web.config. However the page will still crash if file size is greater than maxRequestLength!!Then I override OnError and tried to display some friendly message using Response.write, but still get "cannot display the webpage" error and not my custom message. How can I completely override the asp.net default behavior on this. Don't forget to click &quo...

Max File size!
Does anyone know what the maximum file size is for a SQLAnywhere 5.0 database, running the 16-Bit engine on NT 4 server. The SQL books say 2G, they also state that if the engine is running on an NTFS partition that the limitation of file size is determined by the OS. Does this apply to the 16-Bit engine? Thanks in advance for your help. Eric Vinson Eric_Vinson wrote... > Does anyone know what the maximum file size is for a SQLAnywhere 5.0 > database, running the 16-Bit engine on NT 4 server. The SQL books say 2G, > they also state that if the engine is runnin...

Web resources about - max size of sqla 9 log file - sybase.sqlanywhere.general

Size - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Seeing Plus-Size Models Could Cause Unhealthy Habits: SFU Study 8
... for using scary-thin models that promote unhealthy habits — and now some researchers are suggesting the same can happen with plus-sized models, ...

Review: Can the BrydgeMini keyboard for the iPad mini live up to the full size version?
... gold), the same three-month battery life and weigh the same 300g. One of the beauties of the original is that you pretty much get a full-size ...

Optimize PNGs, GIFs and JPEGs to cut their file size
PNGmicro, GIFmicro and JPEGmicro are freeware Windows tools which optimize images to reduce their size. Each program offers lossless compression ...

Amazon deal: Huge discount on a portable phone charger the size of a lipstick
Get a lipstick-sized portable phone charger that can attach to your key ring and fit into your pocket with your phone. The Anker PowerCore+ Mini ...

The Ultimate Social Media Image Size Guide 2016
... you know that it is imperative to keep up with the trends. You need to know best practices, effective strategies, and details like image sizes ...

UK Electric Taxi Company Looks To Double In Size Via Crowdfunding
... Obsession. The electric taxi company eConnect Cars has launched a new crowdfunding campaign to help achieve its plans to double its fleet size ...

Netflix Dropping Its “One-Size-Fits-All” Streaming Algorithm
... result of the company’s coding system. Anne Aaron, Netflix video algorithms manager, tells Variety that the company realized the “one-size-fits-all” ...

PlayStation VR comes with a 'Wii size' processor box
... additional processing power for VR software. Basically, imagine the expansion pack for the N64, only it's external and "around the size of ...

Samsung aims to reduce pricing for small- to medium-size OLED panels 20% by mid-2016, says report
Samsung Display is expected to drop pricing for small- to medium-size OLED panels 20% by mid-2016 in order to meet requirements for a surge in ...

Resources last updated: 12/17/2015 11:20:24 PM