Pure performance after restoring to different server

Hi All,
When I restore our production database that run very well to the
different server the performance becomes very pure. I am using DOTNET
front end app to access the database.
Can anybody tell me how do I go about this problem.
Is there some kind of checklist that I can go through or is there some
options that I didn't set when I did restore operation (like my be
statistics,etc).
I've checked the indexes and they all seem to be in place.
The server itself hardware-wise is identical to the production one.
Any help is greatly appreciated.The first step is to run Profiler and get the duration of your queries on
the old server vs. the new server. This will tell you if it's the database
server that's taking the extra time or if it's network latency, poor
connection, or some other problem.
"UnkleVo" <isharko@.att.net> wrote in message
news:a3538463.0403240818.1a23655e@.posting.google.com...
> Hi All,
> When I restore our production database that run very well to the
> different server the performance becomes very pure. I am using DOTNET
> front end app to access the database.
> Can anybody tell me how do I go about this problem.
> Is there some kind of checklist that I can go through or is there some
> options that I didn't set when I did restore operation (like my be
> statistics,etc).
> I've checked the indexes and they all seem to be in place.
> The server itself hardware-wise is identical to the production one.
> Any help is greatly appreciated.

Pure MS-DOS Connection to SQL-Server?

Hi,

I want to use pure MS-DOS-Handhelds for warehouse keeping. Therefore I would like to get a connection to our SQL-Server from MS-DOS. Unfortunately, ISQL or OSQL just work in a DOS-Box from Windows with ODBC or ADO installed.

Is there a possibility or a program that I can use to question our database from a DOS-program?

Thanks in advance

-Oliver-You will need something to handle the datasteam if you connect from the handheld - the equivalent of mssqlrv32.

Another option is to connect to something else on the server - like a com object which then handles the database access - bit like iis and mts.

I'm sure there are plenty of ways of doing this if you could find someone who knows how to code in dos.

A not very nice way would be to put the create a text file on the server with the request. A task runs on the server looking for these text files, executes the request and creates another text file with the result - the handheld opens that text file and reads the result.|||isql & osql use DB-Library to connect to SQL Server. I have used this sollution (may years ago) to connect to Sybase on Win 3.1, Should work just fine on MS-DOS/SQL Server.sql