Hello

A client has MS SQL Server installed, and all the idx files are now identified as "SQL Server replication snapshot index script" files. Could this fact
alone cause the massive slow-down that this site is experiencing?

They have ruled out an anti-virus system as being the cause of the slow down; is it possible that the MS replication system is responsible?

Regards & TIA

Peter

I highly doubt it. What you're seeing is a simple windows file association.
MS SQL replication snapshot agent maintains it's own files under its file
structure and is not even looking outside (like in your dbisam folders) so
i'm very confident that dbsiam idx files are not being read by ms sql.

In terms of slowdown : did that conincide with MS SQL install? MS-SQL could
very well be starving DBISAM for cpu cycles, disk io and network bandwidth.

You need to provide more info on what exactly has slowed down? What other
changes have taken place on the system - in addition to sql have they
installed any other software, have you updated dbisam, etc

Raul




"Peter" <peter@petercrain.com> wrote in message
news:B61C8520-EAA5-42BE-9C99-D5A0A5FA08B3@news.elevatesoft.com...
> Hello
>
> A client has MS SQL Server installed, and all the idx files are now
> identified as "SQL Server replication snapshot index script" files. Could
> this fact
> alone cause the massive slow-down that this site is experiencing?
>
> They have ruled out an anti-virus system as being the cause of the slow
> down; is it possible that the MS replication system is responsible?
>
> Regards & TIA
>
> Peter
>

Peter,

<< They have ruled out an anti-virus system as being the cause of the slow
down; >>

How did they rule it out ?  Some of these anti-virus systems are insidious
and hook into some very low-level portions of the OS.

<< is it possible that the MS replication system is responsible? >>

As Raul indicated, this isn't very likely.

Refresh my memory - what exactly is the issue with performance that you're
seeing ?  A link to a previous discussion is fine, if you've got it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

<<Refresh my memory - what exactly is the issue with performance that you're
seeing ?  A link to a previous discussion is fine, if you've got it.>>

No, there has been no previous discussion on this, and yes, the slowdown did coincide with the installation of MS SQL Server, which another program
uses. I can't ask them to un-install MS SQL Server, and I am at a loss as to the best way to handle the problem.

Regards

Peter

"Peter" <peter@petercrain.com> wrote in message
news:B61C8520-EAA5-42BE-9C99-D5A0A5FA08B3@news.elevatesoft.com...
> Hello
>
> A client has MS SQL Server installed, and all the idx files are now
> identified as "SQL Server replication snapshot index script" files. Could
> this fact
> alone cause the massive slow-down that this site is experiencing?
>

Unlikely. Is this file sharing or C/S? Can they temporarily stop SQL and se
if that is the cause?

Robert

Peter,

<< No, there has been no previous discussion on this, and yes, the slowdown
did coincide with the installation of MS SQL Server, which another program
uses. I can't ask them to un-install MS SQL Server, and I am at a loss as to
the best way to handle the problem. >>

Are you using the DBISAM Database Server, or is the server machine acting as
a file server for the database files ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

DBISAM is running as a File Server.

It is our plan to test our app in isolation, ie, with MS SQL Server turned off, then with the NOD antii-virus turned off, to see if we can determine the
cause.

Regards

Peter

SQL Server places a huge load on a system. I would fully expect a DBISAM app to take a big
hit if SQL Server is loaded on the same box.

Also, SQL Server performance is seriously hit if anything else on the box does disk IO.

I would advise:
a) Use two boxes (that is what virtual machines are for...
b) If on one box, use two different disk systems, one for SQL Server, one for DBISAM