Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Web Hosts Reseller Programmes
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Web Hosts Reseller Programmes
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
pipeten View Drop Down
Newbie
Newbie


Joined: 23 February 2003
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote pipeten Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2006 at 4:23pm
Originally posted by Info_Tech Info_Tech wrote:

Usually companies that use MS SQL will 'dedicate' a box just for the SQL server. So no matter how much memory you have on that box SQL will attempt to use all of it for best performance... at least that's what one of the IT instructors in this school told me.



I'm not sure, i'm not the Windows guru here myself but our mssql server seems to have ~2GB free out of 4GB (SQL Server 2005). Like was said previously I'd recommend MySQL for most situations, then Postgres and MsSQL through to Oracle and such.




Edited by pipeten - 20 October 2006 at 4:23pm
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2006 at 4:28pm

Interesting... did you setup that server yourself? I know many admins who know SQL tricks that they usually select a fixed-size of memory when they install SQL.
"When it gets dark enough, you can see the stars"
-Charles A. Beard
Back to Top
Amateur View Drop Down
Senior Member
Senior Member
Avatar

Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Amateur Quote  Post ReplyReply Direct Link To This Post Posted: 23 October 2006 at 12:29am
Re my question, thanks for the help. I will have a look at the developer package you speak of BoRg when details are available. Thanks
Back to Top
pipeten View Drop Down
Newbie
Newbie


Joined: 23 February 2003
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote pipeten Quote  Post ReplyReply Direct Link To This Post Posted: 23 October 2006 at 8:42am
Originally posted by Info_Tech Info_Tech wrote:

Interesting... did you setup that server yourself? I know many admins who know SQL tricks that they usually select a fixed-size of memory when they install SQL.



Nah i'm the Linux/PHP monkey here. It's a Dual Xeon Dell 2850 only serving SQL Server 2005 for our shared hosting so I would assume they haven't applied memory limits for that reason.
Back to Top
Amateur View Drop Down
Senior Member
Senior Member
Avatar

Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Amateur Quote  Post ReplyReply Direct Link To This Post Posted: 25 October 2006 at 10:04pm
Quick question, as a web developer, what hosting specification is the norm to offer you client? I know it depends on size of client, potential etc, but just reequire ball park figures.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.