Sunday, January 18, 2009

using SSIS for send out mail

Here's my code that uses both port and BCC:

fromAddress = New MailAddress("foo@bar.co.uk", "Database Mail")
toAddress = New MailAddress("somebody@somewhere.co.uk", "Data Group")
bccAddress = New MailAddress("somebody.else@somewhere.co.uk", "Data Group")

message = New MailMessage(fromAddress, toAddress)
messag.Bcc.Add(bccAddress)
message.Subject = "Data Mart Load Start"
message.Priority = MailPriority.High
message.IsBodyHtml = False
message.Body = "The Data Mart load process has started. Please exit all reporting systems until notified that the load process has completed."

smtpClient = New SmtpClient("mail.bar.co.uk", 2525)
smtpClient.Credentials = New System.Net.NetworkCredential("login", "password")
smtpClient.Send(message)
Dts.TaskResult = Dts.Results.Success

Thursday, January 15, 2009

Maximum JVM Heap Size 32/64bit (For reference only)

Maximum JVM Heap Size 32/64bit
An important calculation to keep in mind is:
(Managed Heap + native heap + (thread stack size * number of threads)) cannot exceed 2GB on 32bit
x86 Windows or Linux systems
This is a limitation of the Sun Java VM. It means that even if you install 4GB of RAM into your server, a
single instance of the JVM cannot grow beyond 2GB on a 32bit server machine.
Note: Note that a 64 bit OS/JVM has much bigger values. It is recommended that a 64bit OS with large
memory hardware (>2GB assigned to the JVM) is used for deployments of >250 concurrent or >2500
casual users.
You can also setup your machine to cluster if you prefer to solve multi-user access performance issues
with additional machines rather than a single powerful server.

Performance Tuning Code Samples

http://java.sun.com/developer/codesamples/performance.html

JVM Structure

http://java.sun.com/docs/books/jvms/

 有排睇..