Hi I am using JDB with SQL Server to call Stored Procedures..
The problem is that it is working fine for some time.. But after a
certain period the time taken to execute rises to around 15 to 50 secs
from 1 sec .After restart it again starts working fine...
can anyone tell me the reason for this behaviortry to update the statistics of your tables or defrag your indexes
"Yogi" <sendpost@.gmail.com> wrote in message
news:1148306840.530834.91440@.j33g2000cwa.googlegroups.com...
> Hi I am using JDB with SQL Server to call Stored Procedures..
> The problem is that it is working fine for some time.. But after a
> certain period the time taken to execute rises to around 15 to 50 secs
> from 1 sec .After restart it again starts working fine...
> can anyone tell me the reason for this behavior
>|||Two things to check for:
See if you get different execution plans
See if you have any blocking
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yogi" <sendpost@.gmail.com> wrote in message
news:1148306840.530834.91440@.j33g2000cwa.googlegroups.com...
> Hi I am using JDB with SQL Server to call Stored Procedures..
> The problem is that it is working fine for some time.. But after a
> certain period the time taken to execute rises to around 15 to 50 secs
> from 1 sec .After restart it again starts working fine...
> can anyone tell me the reason for this behavior
>
Showing posts with label performance. Show all posts
Showing posts with label performance. Show all posts
Friday, March 9, 2012
Occasional Very Slow Performance.. with SQL Server 2000
Hi I am using JDB with SQL Server to call Stored Procedures..
The problem is that it is working fine for some time.. But after a
certain period the time taken to execute rises to around 15 to 50 secs
from 1 sec .After restart it again starts working fine...
can anyone tell me the reason for this behaviortry to update the statistics of your tables or defrag your indexes
"Yogi" <sendpost@.gmail.com> wrote in message
news:1148306840.530834.91440@.j33g2000cwa.googlegroups.com...
> Hi I am using JDB with SQL Server to call Stored Procedures..
> The problem is that it is working fine for some time.. But after a
> certain period the time taken to execute rises to around 15 to 50 secs
> from 1 sec .After restart it again starts working fine...
> can anyone tell me the reason for this behavior
>|||Two things to check for:
See if you get different execution plans
See if you have any blocking
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yogi" <sendpost@.gmail.com> wrote in message
news:1148306840.530834.91440@.j33g2000cwa.googlegroups.com...
> Hi I am using JDB with SQL Server to call Stored Procedures..
> The problem is that it is working fine for some time.. But after a
> certain period the time taken to execute rises to around 15 to 50 secs
> from 1 sec .After restart it again starts working fine...
> can anyone tell me the reason for this behavior
>
The problem is that it is working fine for some time.. But after a
certain period the time taken to execute rises to around 15 to 50 secs
from 1 sec .After restart it again starts working fine...
can anyone tell me the reason for this behaviortry to update the statistics of your tables or defrag your indexes
"Yogi" <sendpost@.gmail.com> wrote in message
news:1148306840.530834.91440@.j33g2000cwa.googlegroups.com...
> Hi I am using JDB with SQL Server to call Stored Procedures..
> The problem is that it is working fine for some time.. But after a
> certain period the time taken to execute rises to around 15 to 50 secs
> from 1 sec .After restart it again starts working fine...
> can anyone tell me the reason for this behavior
>|||Two things to check for:
See if you get different execution plans
See if you have any blocking
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yogi" <sendpost@.gmail.com> wrote in message
news:1148306840.530834.91440@.j33g2000cwa.googlegroups.com...
> Hi I am using JDB with SQL Server to call Stored Procedures..
> The problem is that it is working fine for some time.. But after a
> certain period the time taken to execute rises to around 15 to 50 secs
> from 1 sec .After restart it again starts working fine...
> can anyone tell me the reason for this behavior
>
Wednesday, March 7, 2012
Obtaining Hotfix
We're experiencing the problem describe in MS Knowledge
Base Article - 812915 "Performance monitor shared memory
setup failed: -1" error message when you start SQL
Server. The article states there is a support hotfix
available through Microsoft Product Support Services.
We're currently evaulating SQL server so we're using the
Enterprise Evaluation Edition. We like to obtain the
hotfix ( preferably for free ), but since we have
evaluation edition we don't know how to go about this.
Can we get the hotfix?
(a) I don't think you can apply patches and hotfixes to the evaluation
edition, but I'm not 100% positive. Did you install the latest release of
the evaluation edition, or have you been running it for a while?
(b) you can't just bypass product support and download a hotfix "for
free"... if it's a bug, and you can demonstrate to PSS that you are affected
by it, then you will be provided the file and refunded the cost of the call.
http://www.aspfaq.com/
(Reverse address to reply.)
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:886b01c49606$7e287f90$a501280a@.phx.gbl...
> We're experiencing the problem describe in MS Knowledge
> Base Article - 812915 "Performance monitor shared memory
> setup failed: -1" error message when you start SQL
> Server. The article states there is a support hotfix
> available through Microsoft Product Support Services.
> We're currently evaulating SQL server so we're using the
> Enterprise Evaluation Edition. We like to obtain the
> hotfix ( preferably for free ), but since we have
> evaluation edition we don't know how to go about this.
> Can we get the hotfix?
Base Article - 812915 "Performance monitor shared memory
setup failed: -1" error message when you start SQL
Server. The article states there is a support hotfix
available through Microsoft Product Support Services.
We're currently evaulating SQL server so we're using the
Enterprise Evaluation Edition. We like to obtain the
hotfix ( preferably for free ), but since we have
evaluation edition we don't know how to go about this.
Can we get the hotfix?
(a) I don't think you can apply patches and hotfixes to the evaluation
edition, but I'm not 100% positive. Did you install the latest release of
the evaluation edition, or have you been running it for a while?
(b) you can't just bypass product support and download a hotfix "for
free"... if it's a bug, and you can demonstrate to PSS that you are affected
by it, then you will be provided the file and refunded the cost of the call.
http://www.aspfaq.com/
(Reverse address to reply.)
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:886b01c49606$7e287f90$a501280a@.phx.gbl...
> We're experiencing the problem describe in MS Knowledge
> Base Article - 812915 "Performance monitor shared memory
> setup failed: -1" error message when you start SQL
> Server. The article states there is a support hotfix
> available through Microsoft Product Support Services.
> We're currently evaulating SQL server so we're using the
> Enterprise Evaluation Edition. We like to obtain the
> hotfix ( preferably for free ), but since we have
> evaluation edition we don't know how to go about this.
> Can we get the hotfix?
Monday, February 20, 2012
Objects in Procedure or Data Cache
I am having some performance issues on my server and wish to track down the particular objects responsible.
Is there any way of determining which objects are in memory?
Many thanks.
Dontable "syscacheobjects" in master database, for cache usage.
setting up a trace in SQL Profiler is also useful
des|||Thanks Des,
It provides some of what I am looking for. I don't seem to find objects of type 'user table' being generated. My SQL Server reports to be using something like 1.4 GB memory from Sysmon. I was hoping that syscacheobjects will shed like on the objects in memory. However, I will continue with the profiler.
Many thanks once more.
Don
Originally posted by DesmondX
table "syscacheobjects" in master database, for cache usage.
setting up a trace in SQL Profiler is also useful
des|||an easy way to keep unnecessary stuff out of memory is to run a scheduled "checkpoint" command on each database every few hours, to flush the memory to disk...
good luck sorting it out...
des
Is there any way of determining which objects are in memory?
Many thanks.
Dontable "syscacheobjects" in master database, for cache usage.
setting up a trace in SQL Profiler is also useful
des|||Thanks Des,
It provides some of what I am looking for. I don't seem to find objects of type 'user table' being generated. My SQL Server reports to be using something like 1.4 GB memory from Sysmon. I was hoping that syscacheobjects will shed like on the objects in memory. However, I will continue with the profiler.
Many thanks once more.
Don
Originally posted by DesmondX
table "syscacheobjects" in master database, for cache usage.
setting up a trace in SQL Profiler is also useful
des|||an easy way to keep unnecessary stuff out of memory is to run a scheduled "checkpoint" command on each database every few hours, to flush the memory to disk...
good luck sorting it out...
des
Subscribe to:
Posts (Atom)