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.

MS SQL Server vs. Sybase: xp_cmdshell

4 posts in Windows NT Last posting was on 2001-05-08 09:29:03.0Z
Jorge Posted on 2001-05-04 22:38:20.0Z
From: "Jorge" <iamjas99@hotmail.com>
Subject: MS SQL Server vs. Sybase: xp_cmdshell
Date: Fri, 4 May 2001 18:38:20 -0400
Lines: 11
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <GsId82O1AHA.254@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: hboc.com 139.177.224.128
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:799
Article PK: 1087406

I am a DBA of both platforms. I use the xp_cmdshell proc alot on MS SQL
Server (6.5 and 7.0). I have noticed before that when I run the same
process under Sybase (11.9.2), it does not run nearly as fast. Does anyone
know the reason for this and how I can get better performance out of Sybase'
version of xp_cmdshell?

Thanks in advance.

Jorge Ascunce


Jim Egan Posted on 2001-05-07 14:32:58.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: MS SQL Server vs. Sybase: xp_cmdshell
Date: Mon, 7 May 2001 08:32:58 -0600
Message-ID: <MPG.15606001a60fa43b98b324@forums.sybase.com>
References: <GsId82O1AHA.254@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
NNTP-Posting-Host: 157.133.56.39
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:792
Article PK: 1087399


iamjas99@hotmail.com wrote...
> I am a DBA of both platforms. I use the xp_cmdshell proc alot on MS SQL
> Server (6.5 and 7.0). I have noticed before that when I run the same
> process under Sybase (11.9.2), it does not run nearly as fast. Does anyone
> know the reason for this and how I can get better performance out of Sybase'
> version of xp_cmdshell?
>

Does it run slow the first time it is executed and then quicker each subsequent time?
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Jorge Posted on 2001-05-07 15:38:34.0Z
From: "Jorge" <iamjas99@hotmail.com>
References: <GsId82O1AHA.254@forums.sybase.com> <MPG.15606001a60fa43b98b324@forums.sybase.com>
Subject: Re: MS SQL Server vs. Sybase: xp_cmdshell
Date: Mon, 7 May 2001 11:38:34 -0400
Lines: 40
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <O1Fwa6w1AHA.191@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: hboc.com 139.177.224.128
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:791
Article PK: 1087398

I ran a simple test:

exec xp_cmdshell 'dir c:\'

I don't have exact numbers here but it seemed to take about 10-15 seconds to
return a result set.
Running the same command again returned almost immediately. I have not tried
this on the processes that I previously referred to yet.

Here's a thought: the Sybase XPserver service was not on to begin with. When
Sybase gets called with an extended stored proc, I believe that Sybase will
turn the service on if not initialized. This can take time. However, I
cannot turn the service on through the NT Services window. It gives me a
failure. But Sybase turns it on successfully every time. Why is that?

Jorge

Jim Egan wrote in message ...
>iamjas99@hotmail.com wrote...
>> I am a DBA of both platforms. I use the xp_cmdshell proc alot on MS SQL
>> Server (6.5 and 7.0). I have noticed before that when I run the same
>> process under Sybase (11.9.2), it does not run nearly as fast. Does
anyone
>> know the reason for this and how I can get better performance out of
Sybase'
>> version of xp_cmdshell?
>>
>
>Does it run slow the first time it is executed and then quicker each
subsequent time?
>--
>Jim Egan [TeamSybase]
>Senior Consultant
>Sybase Professional Services
>
>Get your free subscription to PowerTimes at http://www.powertimes.com


Tony Imbierski Posted on 2001-05-08 09:29:03.0Z
Message-ID: <3AF7BC5F.7E6F3E16@sybase.com>
Date: Tue, 08 May 2001 10:29:03 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: MS SQL Server vs. Sybase: xp_cmdshell
References: <GsId82O1AHA.254@forums.sybase.com> <MPG.15606001a60fa43b98b324@forums.sybase.com> <O1Fwa6w1AHA.191@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 49
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:783
Article PK: 1087390


Jorge wrote:

> I ran a simple test:
>
> exec xp_cmdshell 'dir c:\'
>
> I don't have exact numbers here but it seemed to take about 10-15 seconds to
> return a result set.
> Running the same command again returned almost immediately. I have not tried
> this on the processes that I previously referred to yet.
>

As you noticed in your next para, this is indeed because the first time through
the server starts up the xpserver in order to process the command. Once up,
xpserver remains up for the lifetime of the main server. It gets shut down when
the main server is shutdown. So you only incur this time delay once per boot.

>
> Here's a thought: the Sybase XPserver service was not on to begin with. When
> Sybase gets called with an extended stored proc, I believe that Sybase will
> turn the service on if not initialized. This can take time. However, I
> cannot turn the service on through the NT Services window. It gives me a
> failure. But Sybase turns it on successfully every time. Why is that?
>

Without looking I don't really know, except to say "it wasn't designed that
way".


>
> Jorge
>

cheers,
tonyi


>
> Jim Egan wrote in message ...
> >iamjas99@hotmail.com wrote...
> >> I am a DBA of both platforms. I use the xp_cmdshell proc alot on MS SQL
> >> Server (6.5 and 7.0). I have noticed before that when I run the same
> >> process under Sybase (11.9.2), it does not run nearly as fast. Does
> anyone
> >> know the reason for this and how I can get better performance out of
> Sybase'
> >> version of xp_cmdshell?
> >>
> >
> >Does it run slow the first time it is executed and then quicker each
> subsequent time?
> >--
> >Jim Egan [TeamSybase]
> >Senior Consultant
> >Sybase Professional Services
> >
> >Get your free subscription to PowerTimes at http://www.powertimes.com

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --