Re: [cfaussie] Re: CF9 SQL Server on Amazon Web Servers

2012-04-01 Thread Stephen M
@googlegroups.com [mailto:cfaussie@googlegroups.com] *On Behalf Of *Stephen M *Sent:* Thursday, March 29, 2012 12:56 AM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Re: CF9 SQL Server on Amazon Web Servers On Friday, January 27, 2012 10:21:44 PM UTC+11, Stephen M wrote: I've replicated

RE: [cfaussie] Re: CF9 SQL Server on Amazon Web Servers

2012-04-01 Thread charlie arehart
SQL Server on Amazon Web Servers On Friday, March 30, 2012 10:12:29 AM UTC+11, charlie arehart wrote: Stephen, I'll share some thoughts. This is hard to explain in email because things are often not at all what they may seem on the surface. I help people solve these kind of problems all the time

RE: [cfaussie] Re: CF9 SQL Server on Amazon Web Servers

2012-03-29 Thread charlie arehart
. /charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Stephen M Sent: Thursday, March 29, 2012 12:56 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF9 SQL Server on Amazon Web Servers On Friday, January 27, 2012 10:21:44 PM UTC+11, Stephen M

[cfaussie] Re: CF9 SQL Server on Amazon Web Servers

2012-03-28 Thread Stephen M
On Friday, January 27, 2012 10:21:44 PM UTC+11, Stephen M wrote: I've replicated this problem on my local workstation using a network db server, so its no longer about Amazon. I can get the timeout error on the stored proc as below. But the problem is I am getting this timeout at the 120

[cfaussie] Re: CF9 SQL Server on Amazon Web Servers

2012-01-29 Thread Stephen M
On Jan 27, 10:38 pm, Kym Kovan dev-li...@mbcomms.net.au wrote: Hi Steven, you don't mention what OS you are running but in general with 64bit machines it is good to double the old 32 bit recommendations as a first pass in server tuning. For 2008 R2 the OS takes a gig or more with its