If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > survey of your hardware/software (was "IT Services Consulting Company")

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-04-08, 03:25
john_sm john_sm is offline
SPAMMER
 
Join Date: Jul 2007
Posts: 10
survey of your hardware/software (was "IT Services Consulting Company")

Hey Folks - We need your help. We were hoping, we could gain from your experience with implementing server virtualization. When should we be using Red Hat Virtualization, Citrix Virtualization, Xen Virtualization, Microsoft Virtualization, Oracle Virtualization and VMWare. I will be very interested in learning from your first hand experince. I will also like to know, under what situations is one virtualization prefered over the other. - Thanks for your help
Reply With Quote
  #2 (permalink)  
Old 01-04-08, 09:45
PMASchmed PMASchmed is offline
Registered User
 
Join Date: Jun 2004
Location: Long Island
Posts: 696
Yes, I would like to know too. I've seen feedback both pro and con in regards to SQL Server virtualization. Some state do not do it on any production DB, while others say it is the best thing since sliced bread (sorry for the outdated pun).
Reply With Quote
  #3 (permalink)  
Old 01-06-08, 20:57
LoztInSpace LoztInSpace is offline
Registered User
 
Join Date: Feb 2007
Posts: 62
VMs have a lot of very good applications but we do not virtualise our SQL servers because of the overhead of the VM and how it can limit the use of resources that are actually free. SQL Server can run multiple databases at a time anyway which gives us pretty much what we need.
The questions I would have for you are
a) What are your aims in this?
b) What are the problems you are currently encouterting
c) What is inadequate about running several databases on one install?
Reply With Quote
  #4 (permalink)  
Old 01-07-08, 01:13
john_sm john_sm is offline
SPAMMER
 
Join Date: Jul 2007
Posts: 10
survey of your hardware/software (was "IT Services Consulting Company")

Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us
Reply With Quote
  #5 (permalink)  
Old 01-07-08, 02:52
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
If another mod deems another forum more appropriate for the thread please be my guest.
Reply With Quote
  #6 (permalink)  
Old 01-08-08, 11:12
db2hrishy db2hrishy is offline
Registered User
 
Join Date: Jun 2004
Posts: 115
Hi

When budget is a constraint then i prefer
Centos and Mysql
When We have a large budget
Solaris and Oracle or Aix and Db2
When it comes to departmental databases and we have the budget
Then its Sqlserver and Windows

When it comes to business intelligence then
Sqlserver Analysis service for certain category of departmental users.

When it comes to Packaged Business Intelligence applications
Then it would
Hyperion Cognos and SAS.
Hyperion and SAS mostly in Marketing and Financial Companies.

When it comes to Datamarts
Netezaa and DataAllegro

regards
Hrishy
Reply With Quote
  #7 (permalink)  
Old 01-10-08, 04:11
quyloc quyloc is offline
Registered User
 
Join Date: Jan 2008
Posts: 3
It depends on your customers and your niche
Reply With Quote
  #8 (permalink)  
Old 01-10-08, 13:35
ortho ortho is offline
Registered User
 
Join Date: Nov 2006
Location: Quebec
Posts: 172
Do not forget that you can use different instance of SQL SERVER 2005 into the same server. So if your databases uses the same version of SQL, and that you do not want the database to be on the same server (software side), you can use different install which is more optimized than using VMs.

With MS SQL SERVER 2005, you can install up to 50 instances on the same server.

Correct me if I'm wrong.

Regards

Or Tho
__________________
Less is more.
How long is now?
http://www.lesouterrain.com
Reply With Quote
  #9 (permalink)  
Old 01-18-08, 05:37
john_sm john_sm is offline
SPAMMER
 
Join Date: Jul 2007
Posts: 10
survey of your hardware/software (was "IT Services Consulting Company")

Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us
Reply With Quote
  #10 (permalink)  
Old 01-18-08, 05:59
Marvels Marvels is offline
Registered User
 
Join Date: Jul 2003
Location: Amsterdam, Nederland
Posts: 449
Post Re

For a "IT Services Consulting company" you have a lot of questions.
And i think you'll have to specify your location or do you want to consult the whole world? each country has itīs specific

Think you have first to go and see whats out there your self, a lot of hear say dosn't make you an specialist your self.

See what mess, there is out there. See if you can clean a org. with 5 diffrent Databasess ; 3 platforms ; over 5000 users with all kinds of different hardware/software and not mensioning the versions /partial setups /dll's / usersettings/ regional setting (and what so ever) on 5 locations. This is still a minor example.

see a forum on anny topic, you'll have 1 question 1001 solutions on how to solve it and nobody will say thats the correct one because they will/can all work.

Still you have 1 million probility whats wrong
if a pice of code / hardware did work yesterday and won't work the next what's the cause.
is it an update on the machine or server. did the autorisation change of the user or expire. or did the clean-up crew clean the office and bumped on your network cable and you just have to click it in again.
Reply With Quote
  #11 (permalink)  
Old 01-18-08, 06:24
john_sm john_sm is offline
SPAMMER
 
Join Date: Jul 2007
Posts: 10
Hardware, Database, Business Intelligence

Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us
Reply With Quote
  #12 (permalink)  
Old 01-18-08, 06:30
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
john_sm - please can you check your private messages. I believed you should have received one from one of the other moderators.
Reply With Quote
  #13 (permalink)  
Old 01-18-08, 06:59
Diabolic Diabolic is offline
Registered User
 
Join Date: Jul 2007
Posts: 96
Where I work at we usually buy hardware from HP with a support contract and all the expensive and fancy things that come along with that. The hardware itself varies from project to project.

In 2008 Oracle will continue to be the database of choice for the majority of the high-end segment. Microsoft SQL Server will prolly increase it's market share with the release of the new products in 2008. Microsoft Customers and End-Clients are hopping that SQL Server 2008 doesn't become the Windows Vista of the Databases.

A big stake of the customers are eager to unleash decent reporting and analysis for their always increasing data collections, which can boost MS SQL Server implementatios as an out of the box sollution that fullfills the majority of the requirements within the same product. Still on the MS track, sharepoint solutions demand is likely to increase in all levels of demand.

Sun has a new baby called MySql and it will be interesting to see its strategy to lure enterprise costumers into adopting MySql Dbs, in dispite of commercial versions. This of course preferentially boundled with other sun products and commercial support contracts.

Linux will continue to be the primary DB OS, pushed by Oracle's market share and strategy. Along with that, end-users and businesses will continue to argue that Vista is not good enough and will keep their efforts with their SaveXp.com campaign.

That's pretty much how I see things for 2008 =)

Last edited by Diabolic; 01-18-08 at 07:03.
Reply With Quote
  #14 (permalink)  
Old 01-21-08, 09:08
john_sm john_sm is offline
SPAMMER
 
Join Date: Jul 2007
Posts: 10
Hardware, Database, Business Intelligence

Hello all. We are just starting up an IT Services Consulting company, we are currently 3 people, our current skills are Oracle DBA & MYSQL, and somewhat SQL Server, and we will like to learn from your experience. First is regarding the Hardware - what hardware and OS do you currently use and what hardware and OS do you think you may use over the next year or so. Do you have any favorite hardware vendor, and if so why. Also, among Oracle Database, SQL Server Database, Websphere and MYSQL, are you seeing any one database doing better than the rest. Also, we would like to get your views, if we want to also offer Business Intelligence services, are you seeing any one BI solution being a favorite over the other. Thanks for helping us
Reply With Quote
  #15 (permalink)  
Old 01-21-08, 10:39
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,511
threads merged (again)

spammer banned
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On