Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Running Sybase ASE in a VM

3 posts in General Discussion Last posting was on 2012-10-19 13:06:00.0Z
itguy2 Posted on 2012-10-12 16:29:14.0Z
Sender: 5df4.507843e0.1804289383@sybase.com
From: itguy2
Newsgroups: sybase.public.ase.general
Subject: Running Sybase ASE in a VM
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5078455a.5e08.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 12 Oct 2012 09:29:14 -0700
X-Trace: forums-1-dub 1350059354 172.20.134.41 (12 Oct 2012 09:29:14 -0700)
X-Original-Trace: 12 Oct 2012 09:29:14 -0700, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31429
Article PK: 74317

Hello,

I may not be in the right forum but I have looked over them
and didn't find a better one.

My question is if anything exists for a relative newcomer to
running and optimizing Sybase in a vSphere 5 VM. Another
group is saying they have I/O problems (though they have no
data to back that up because no features were purchased for
our EMC 240) on a Sybase ASE DB thay have moved into a VM.
Also, I will have four or five VMs running it before too
long. It'd be helpful if I could get a Best Practice paper
or a good list of solid optimizing steps for it.

Anyone have a doc, link, suggestion? It'd be appreciated.

Thanks,

George


Cory Sane [TeamSybase] Posted on 2012-10-15 02:47:26.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <5078455a.5e08.1681692777@sybase.com>
In-Reply-To: <5078455a.5e08.1681692777@sybase.com>
Subject: Re: Running Sybase ASE in a VM
Lines: 33
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <507b793e@forums-1-dub>
Date: 14 Oct 2012 19:47:26 -0700
X-Trace: forums-1-dub 1350269246 172.20.134.152 (14 Oct 2012 19:47:26 -0700)
X-Original-Trace: 14 Oct 2012 19:47:26 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31434
Article PK: 74322

George,

There have been many changes in the ASE Server configuration in the last few years.
Depending on the settings ASE 15.7 can behave very differently.

What version are you using?


--
Cory Sane
[TeamSybase]
Certified Sybase ASE 15.0 Administrator Associate
Certified Sybase ASE 15.0 SQL Developer Professional

"itguy2" wrote in message news:5078455a.5e08.1681692777@sybase.com...
> Hello,
>
> I may not be in the right forum but I have looked over them
> and didn't find a better one.
>
> My question is if anything exists for a relative newcomer to
> running and optimizing Sybase in a vSphere 5 VM. Another
> group is saying they have I/O problems (though they have no
> data to back that up because no features were purchased for
> our EMC 240) on a Sybase ASE DB thay have moved into a VM.
> Also, I will have four or five VMs running it before too
> long. It'd be helpful if I could get a Best Practice paper
> or a good list of solid optimizing steps for it.
>
> Anyone have a doc, link, suggestion? It'd be appreciated.
>
> Thanks,
>
> George


Chris Baker [SAP] Posted on 2012-10-19 13:06:00.0Z
From: "Chris Baker [SAP]" <c.baker@sap.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Running Sybase ASE in a VM
References: <5078455a.5e08.1681692777@sybase.com> <507b793e@forums-1-dub>
In-Reply-To: <507b793e@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50815038@forums-1-dub>
Date: 19 Oct 2012 06:06:00 -0700
X-Trace: forums-1-dub 1350651960 172.20.134.152 (19 Oct 2012 06:06:00 -0700)
X-Original-Trace: 19 Oct 2012 06:06:00 -0700, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31453
Article PK: 74342


On 10/14/2012 10:47 PM, Cory Sane [TeamSybase] wrote:
> George,
>
> There have been many changes in the ASE Server configuration in the last
> few years.
> Depending on the settings ASE 15.7 can behave very differently.
>
> What version are you using?
>
>

If this is a production server, the simplest answer is to ensure that
you are mapping the hardware 1:1 to the ASE in the VM.

Meaning - 1 physical core per ASE engine (or SYB_DEFAULT_POOL thread in
15.7) in the VM and the memory allocated to the ASE host should be fully
mapped to physical.

VM's are great for virtualizing desktops that are idle for 99% of the
time. Not so good for production database servers.

Any performance issues must be investigated at the VM side first.

Chris