ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgs
You have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs
|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:

> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>
sql

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on Windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on Windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:

> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO librari
es
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exact
ly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers do
wn
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
>
>

ms sql server response is slow

Hi ,
i have ms access client program connecting to sql server 2000 wif sp3a
running on windows 2000 server
the user is complaining that the response from the client program is slow
i have check the current activity and there's no much user connected and
there's no lock/blocking process
where could i check further to determine the cause ?
tks & rdgsYou have only begun to scrape the surface of your issue.
There is a lot more that needs to be known to pinpoint anything.
1. Is MS Access using ADO to connect, or is it using the older DAO libraries
to connect?
2. If you are calling a stored procedure, is that individual sproc slow?
Are the tables indexed correctly?
You have to understand where the issue is with the user, and observe exactly
what they are doing - maybe it is the "way" they are doing the operation?
Trace it from their point of view, backwards through the various layers down
to the database. It may be something in the MS Access VBA code that is
causing the contention.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> Hi ,
> i have ms access client program connecting to sql server 2000 wif sp3a
> running on windows 2000 server
> the user is complaining that the response from the client program is slow
> i have check the current activity and there's no much user connected and
> there's no lock/blocking process
> where could i check further to determine the cause ?
> tks & rdgs|||Hi,
i am connected to the SQL server via odbc ver 3.52.
the problem started when the user got the connection failed error while
running the program with SQL State HYP000
i looked into the articles for theis connection failed but it seems not
related in my case
rdgs
"news.microsoft.com" wrote:
> You have only begun to scrape the surface of your issue.
> There is a lot more that needs to be known to pinpoint anything.
> 1. Is MS Access using ADO to connect, or is it using the older DAO libraries
> to connect?
> 2. If you are calling a stored procedure, is that individual sproc slow?
> Are the tables indexed correctly?
> You have to understand where the issue is with the user, and observe exactly
> what they are doing - maybe it is the "way" they are doing the operation?
> Trace it from their point of view, backwards through the various layers down
> to the database. It may be something in the MS Access VBA code that is
> causing the contention.
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:19F3E7F8-E9B6-4B93-8368-9B9FE46F813B@.microsoft.com...
> > Hi ,
> >
> > i have ms access client program connecting to sql server 2000 wif sp3a
> > running on windows 2000 server
> >
> > the user is complaining that the response from the client program is slow
> >
> > i have check the current activity and there's no much user connected and
> > there's no lock/blocking process
> >
> > where could i check further to determine the cause ?
> >
> > tks & rdgs
>
>

MS SQL Server Express connection error from VB.net Program

I am trying to make new connection with SQL Server 2005 Express Database fro
m
my Visual Basic.Net program. I am using connection string as "Dim
connectionString As String = "Data Source=.\SQLEXPRESS;Initial
Catalog=MgmtSystem;User Instance=True".
But it is giving me error as " Failed to generate a user instance of SQL
Server. Only integrated connection can generate a User Instance".
I can connect to this "MgmtSystem" database successfully using Microsoft SQL
Server Management Studio Express though.
What could be the possible reason for this error? How do I get the correct
connection string? and what does integrated connection mean? Your help will
be appreciated.
My application is in Access at the moment, but I am planning to migrate it
to Microsoft SQL Server Express 2005. I am completely new to Microsoft SQL
Server Express 2005 Express version.Fixed it by myself. I changed the connectiuon string to "Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\MgmtSystem.mdf;Initial Catalog=MgmtSystem;Persist
Security Info=True;" ..and it worked..
"Sujata P" wrote:

> I am trying to make new connection with SQL Server 2005 Express Database f
rom
> my Visual Basic.Net program. I am using connection string as "Dim
> connectionString As String = "Data Source=.\SQLEXPRESS;Initial
> Catalog=MgmtSystem;User Instance=True".
> But it is giving me error as " Failed to generate a user instance of SQL
> Server. Only integrated connection can generate a User Instance".
> I can connect to this "MgmtSystem" database successfully using Microsoft S
QL
> Server Management Studio Express though.
> What could be the possible reason for this error? How do I get the correct
> connection string? and what does integrated connection mean? Your help wil
l
> be appreciated.
> My application is in Access at the moment, but I am planning to migrate i
t
> to Microsoft SQL Server Express 2005. I am completely new to Microsoft SQL
> Server Express 2005 Express version.|||Fixed it by myself. I changed the connectiuon string to "Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\MgmtSystem.mdf;Initial Catalog=MgmtSystem;Persist
Security Info=True;" ..and it worked..
"Sujata P" wrote:

> I am trying to make new connection with SQL Server 2005 Express Database f
rom
> my Visual Basic.Net program. I am using connection string as "Dim
> connectionString As String = "Data Source=.\SQLEXPRESS;Initial
> Catalog=MgmtSystem;User Instance=True".
> But it is giving me error as " Failed to generate a user instance of SQL
> Server. Only integrated connection can generate a User Instance".
> I can connect to this "MgmtSystem" database successfully using Microsoft S
QL
> Server Management Studio Express though.
> What could be the possible reason for this error? How do I get the correct
> connection string? and what does integrated connection mean? Your help wil
l
> be appreciated.
> My application is in Access at the moment, but I am planning to migrate i
t
> to Microsoft SQL Server Express 2005. I am completely new to Microsoft SQL
> Server Express 2005 Express version.

MS SQL Server 2005 data folder

It seems SQL Server 2005 can store data in both C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data. But what's the difference of the 2 folders? I accidentally found identical mdf files in the two folders and got confused. Thanks.This is assuming you have more than one database in your SQL Server if you find all your MDF files and LDF files in one and not the other then the second one was created by VS for SQL Server I will leave it alone. Hope this helps.|||

The difference is that the 2 folders are default data folders of 2 different SQL2005 instance. In SQL 2005 the machanism of resolving instance names has been changed, as well as the file locations. For more information, you can refer to:

File Locations for Default and Named Instances of SQL Server 2005

ms sql server 2000 personal edition

Error is occured such as "c:\Program Files\Microsoft SQL Server\80\
tools\BINN\Resources\1033\SEMCROS.RLL could not be loaded" while installing in windows xp sp2Question moved to SQL Server Forum.

Ms SQL Server 2000 Installation Problem

Hi all

when installing MS SQL Server 2k i got these errors :

'This program is used internally by PackageFromTheWeb. It should no be executed directly.' (displays 2 times)

... and at the end of setup .. :

'Setup failed to configure the server. Refer to the server error logs and F:\WINNT\sqlstp.log for more information.'

i have also MSDE installed from visual studio.net

anyone got similar problem ?, anyone has an idea how to cope with this ?

thx in advance

in attachment i include sqlstp.logOriginally posted by krotuski
'This program is used internally by PackageFromTheWeb...
'Setup failed to configure the server. see F:\WINNT\sqlstp.log for more information.'
i have also MSDE installed from visual studio.net

I could only find these 2 error messages that relate to the 2nd error message of the issue you reported.

http://support.microsoft.com/default.aspx?scid=kb;en-us;305680

http://support.microsoft.com/default.aspx?scid=kb;en-us;285100

As for the first Message, I couldn't find anything relating to PackageFromTheWeb. Hope the other 2 help.

As a suggestion, I would suggest doing a backup before attempting anything relating to data manipulation/upgrade.

I also noticed a couple of issues related to upgrading MSDE to SQL server 2000 so be prepared for problems and have your backups handy :)|||thx for answer, but none of these were the cause of a problem, anyway, thx for replying|||Did you determine what the problem was, I am getting the same error.
Thanks|||I have msde and SQL personal edition running simultaniously on my xp development box at home so I don't think there should be a problem running both. I use named instances. computername\msde and computername\sql2000

MS SQL Reporting Services Server - Activation errors

When running the following:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsactivate -c
"C:\Program Files\Microsoft SQL
Server\MSSQL\ReportingServices\ReportServer\RSRepo rtServer.co
nfig" -t

I get the following error:

Failure starting the web service:
System.Exception: The local NT Service is disabled 0x80090005 -->
System.E
xception: 0x80090005
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate. RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate. InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLin eMain(String[]
args, BaseCmdLine instance)
Any insight into this. What am I doing wrong."moedap" <moedap@.yahoo.com> wrote in message
news:1105721152.907594.241730@.c13g2000cwb.googlegr oups.com...
> When running the following:
>
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsactivate -c
> "C:\Program Files\Microsoft SQL
> Server\MSSQL\ReportingServices\ReportServer\RSRepo rtServer.co
> nfig" -t
>
> I get the following error:
> Failure starting the web service:
> System.Exception: The local NT Service is disabled 0x80090005 -->
> System.E
> xception: 0x80090005
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate. RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate. InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLin eMain(String[]
> args, BaseCmdLine instance)
> Any insight into this. What am I doing wrong.

See this thread for one possible reason:

http://groups.google.ch/groups?hl=e...FTNGP09.phx.gbl

Simon

MS SQL for returning no values

Hello,

im having a problem integrating an SQL statement with my program,
it works fine when theres a result but throws an error when there is
no result,
is there anyway in SQL to make up a row if there isnt one that matches
the query for example in this i could put indicator values in the
returned fields then a simple check to see if its a proper field of my
indicator field

I know ISNULL works with single values but that only works if there is
a row returned

Does anyone know of any SQL syntax for MS SQL that when no row is
returned it makes on up and parses it back

Thank you in advance for your help!!

BenAm Tue, 20 Nov 2007 02:57:06 -0800 (PST) schrieb Ben:

Quote:

Originally Posted by

Hello,
>
im having a problem integrating an SQL statement with my program,
it works fine when theres a result but throws an error when there is
no result,

... and what is the error message ??

Quote:

Originally Posted by

Does anyone know of any SQL syntax for MS SQL that when no row is
returned it makes on up and parses it back

I don't see any sense in this, but anyway, you can do something like:

if (select count(*) from persontable where id < 17) 0
select id, lastname, street1, city from persontable where id < 17
else select 0 as id, 'testperson' as lastname, 'noStreet' as street1,
'noCity' as city

bye,
Helmut|||What language is your "Program" in? Check the recordcount on the
dataset returned and go from there, don't return the dummy record.

Cheers,
Jason Lepack

On Nov 20, 5:57 am, Ben <bor...@.gmail.comwrote:

Quote:

Originally Posted by

Hello,
>
im having a problem integrating an SQL statement with my program,
it works fine when theres a result but throws an error when there is
no result,
is there anyway in SQL to make up a row if there isnt one that matches
the query for example in this i could put indicator values in the
returned fields then a simple check to see if its a proper field of my
indicator field
>
I know ISNULL works with single values but that only works if there is
a row returned
>
Does anyone know of any SQL syntax for MS SQL that when no row is
returned it makes on up and parses it back
>
Thank you in advance for your help!!
>
Ben

|||On 20 Nov, 13:33, Jason Lepack <jlep...@.gmail.comwrote:

Quote:

Originally Posted by

What language is your "Program" in? Check the recordcount on the
dataset returned and go from there, don't return the dummy record.
>
Cheers,
Jason Lepack
>
On Nov 20, 5:57 am, Ben <bor...@.gmail.comwrote:
>
>
>

Quote:

Originally Posted by

Hello,

>

Quote:

Originally Posted by

im having a problem integrating an SQL statement with my program,
it works fine when theres a result but throws an error when there is
no result,
is there anyway in SQL to make up a row if there isnt one that matches
the query for example in this i could put indicator values in the
returned fields then a simple check to see if its a proper field of my
indicator field

>

Quote:

Originally Posted by

I know ISNULL works with single values but that only works if there is
a row returned

>

Quote:

Originally Posted by

Does anyone know of any SQL syntax for MS SQL that when no row is
returned it makes on up and parses it back

>

Quote:

Originally Posted by

Thank you in advance for your help!!

>

Quote:

Originally Posted by

Ben- Hide quoted text -

>
- Show quoted text -

The Error Message is: exception : System.NullReferenceException:
Object reference not set to an instance of an object.

and its not really programming its a prebuilt assembly which has to be
used i can only alter the code around it, but this assembly throws an
error if there is nothing there so waht i need is, if there are no
values returned that it creats a dummy value, im not sure if you can
do that using a MS SQL statement

All that this assembly returns is either one record or nothing, pretty
useless i know :/ doesnt even return a recordset

Cheers

Ben|||On 20 Nov, 14:34, Ben <bor...@.gmail.comwrote:

Quote:

Originally Posted by

On 20 Nov, 13:33, Jason Lepack <jlep...@.gmail.comwrote:
>
>
>
>
>

Quote:

Originally Posted by

What language is your "Program" in? Check the recordcount on the
dataset returned and go from there, don't return the dummy record.

>

Quote:

Originally Posted by

Cheers,
Jason Lepack

>

Quote:

Originally Posted by

On Nov 20, 5:57 am, Ben <bor...@.gmail.comwrote:

>

Quote:

Originally Posted by

Quote:

Originally Posted by

Hello,

>

Quote:

Originally Posted by

Quote:

Originally Posted by

im having a problem integrating an SQL statement with my program,
it works fine when theres a result but throws an error when there is
no result,
is there anyway in SQL to make up a row if there isnt one that matches
the query for example in this i could put indicator values in the
returned fields then a simple check to see if its a proper field of my
indicator field

>

Quote:

Originally Posted by

Quote:

Originally Posted by

I know ISNULL works with single values but that only works if there is
a row returned

>

Quote:

Originally Posted by

Quote:

Originally Posted by

Does anyone know of any SQL syntax for MS SQL that when no row is
returned it makes on up and parses it back

>

Quote:

Originally Posted by

Quote:

Originally Posted by

Thank you in advance for your help!!

>

Quote:

Originally Posted by

Quote:

Originally Posted by

Ben- Hide quoted text -

>

Quote:

Originally Posted by

- Show quoted text -

>
The Error Message is: exception : System.NullReferenceException:
Object reference not set to an instance of an object.
>
and its not really programming its a prebuilt assembly which has to be
used i can only alter the code around it, but this assembly throws an
error if there is nothing there so waht i need is, if there are no
values returned that it creats a dummy value, im not sure if you can
do that using a MS SQL statement
>
All that this assembly returns is either one record or nothing, pretty
useless i know :/ doesnt even return a recordset
>
Cheers
>
Ben- Hide quoted text -
>
- Show quoted text -

Hey!

nevermind, my stupid brain thought of another idea, appologies for the
post it seems really stupid now >.< why didint i think of count...
Sigh

Thanks for your help anyway! :D

Regards

Ben

MS SQL 2000 using Mobilink question

Hello,

I am trying to get my PDA program to work on MS SQL 2000, which I originally designed using Sybase ASA 8.

From what I have read, MS SQL 2000 does not support variables as ASA does, but functions may be able to do what I need them to do.

What I am trying to figure out is what I need to do to get it set up so that in MS SQL, there is something that will work like a session-wide variable that holds the user_id, and how to call it from scripts.

Any ideas?Transact SQL definitely supports variables, almost exactly like ASA server does. What you want is available from a function called suser_sname() so I'd just use that.

-PatP|||Ok, thanks.

I will give that a go, and tell you how it works out.