Hi
Within a day of the sql server service being up we're getting memory errors
returned from SQL Server by the applications that use it and query analyser.
I suspect that one of our sp's or jobs is leaking memory. Does anyone know
how i can test which one it is?
Win2k sp4, SQL Server 2000 sp3
Thanks
MattThese articles may help you.
http://www.sql-server-performance.c...nce_audit10.asp
+
http://support.microsoft.com/?id=271624
http://support.microsoft.com/defaul...kb;en-us;316749
http://www.sqlservercentral.com/col...rfinfotable.asp
"Matt" wrote:
> Hi
> Within a day of the sql server service being up we're getting memory error
s
> returned from SQL Server by the applications that use it and query analyse
r.
> I suspect that one of our sp's or jobs is leaking memory. Does anyone kno
w
> how i can test which one it is?
> Win2k sp4, SQL Server 2000 sp3
> Thanks
> Matt
>
>
Showing posts with label applications. Show all posts
Showing posts with label applications. Show all posts
Friday, March 16, 2012
Sunday, March 11, 2012
"SQL Server does not exist or access denied." after installing XP SP2
Hi!
I just installed Windows XP Service Pack 2 on my pc and I cannot make my asp.net applications access any database any more.
I tried starting the application up from the debugger in vs.net, but I got the same behaviour: I can open the login page but as soon as the application tries to connect to SQLServer I get the "SQL Server does not exist or access denied." error message.
I'm trying to connect with trusted_connection.
Can you guys help me out?Try this Microsoft KB article:
http://support.microsoft.com/default.aspx?kbid=839269|||Hi TechMickey,
Did you find a solution to the problem? As you remember I have the same problem and it is still not working.|||Hi bws,
no, I just removed sp2 :-(|||So you took the drastic step. I disabled the firewall but without improvement. I will do like you, get rid of the whole sp2-thing. until I see a solution.
"Server has not yet been opened" - XP
I have the "Crystal Reports Viewer Control" in one of my VB 6.0 applications. The report was working great on the Windows 2000 OS, but when I moved the application to Windows XP it now gives the error "Server has not yet been opened". I have made sure that a system DSN has been created for the ODBC connection. I have connected to the DSN using the "Crystal SQL Connectivity Test Utility - SQLCON32". I even tried registering or re-registering many of the crystal dependencies. I have Crystal Reports 8.5 Professional Edition loaded and the report works fine if I open it with the Professional Edition, but not the viewer. I am baffled.
Code;
'* Start creating the crystal report for the crystal viewer.
Set crystal = New CRAXDRT.Application
Set sRPT = crystal.OpenReport(App.Path & "\DailyIS.rpt")
sRPT.DiscardSavedData
DoEvents
sRPT.Database.Tables(1).SetLogOnInfo "oracle", gDSN, gUserID, gPassWord
sRPT.Database.SetDataSource RS
crViewer.ReportSource = sRPT
crViewer.ViewReport '* (Where the error pops up)
Any ideas what my Windows XP issue might be?'* Start creating the crystal report for the crystal viewer.
Set crystal = New CRAXDRT.Application
Set sRPT = crystal.OpenReport(App.Path & "\DailyIS.rpt")
sRPT.DiscardSavedData
DoEvents
sRPT.Database.SetDataSource RS
crViewer.ReportSource = sRPT
crViewer.ViewReport '* (Where the error pops up)
if you are set ADODB.recordset in CR you don't need
sRPT.Database.Tables(1).SetLogOnInfo "oracle", gDSN, gUserID, gPassWord|||Thank you hensa22 for that information. I commented out that line of code and ran the report in Windows 2000 and received the message "Server has not yet been opened.", but the report displays with that line of code left in. In Windows XP I receive the message "Server has not yet been opened." with or without the code.
Code;
'* Start creating the crystal report for the crystal viewer.
Set crystal = New CRAXDRT.Application
Set sRPT = crystal.OpenReport(App.Path & "\DailyIS.rpt")
sRPT.DiscardSavedData
DoEvents
sRPT.Database.Tables(1).SetLogOnInfo "oracle", gDSN, gUserID, gPassWord
sRPT.Database.SetDataSource RS
crViewer.ReportSource = sRPT
crViewer.ViewReport '* (Where the error pops up)
Any ideas what my Windows XP issue might be?'* Start creating the crystal report for the crystal viewer.
Set crystal = New CRAXDRT.Application
Set sRPT = crystal.OpenReport(App.Path & "\DailyIS.rpt")
sRPT.DiscardSavedData
DoEvents
sRPT.Database.SetDataSource RS
crViewer.ReportSource = sRPT
crViewer.ViewReport '* (Where the error pops up)
if you are set ADODB.recordset in CR you don't need
sRPT.Database.Tables(1).SetLogOnInfo "oracle", gDSN, gUserID, gPassWord|||Thank you hensa22 for that information. I commented out that line of code and ran the report in Windows 2000 and received the message "Server has not yet been opened.", but the report displays with that line of code left in. In Windows XP I receive the message "Server has not yet been opened." with or without the code.
Thursday, February 9, 2012
"Cluster-aware" Applications
If a customer has a na application that accesses SQL
server running on a single machine (Windows 2003 Server)
and then decided to implement an active/passive server
cluster with SQL Server Enterprise, does the application
that accesses the database need to change? I am not sure
what is meant by "cluster-aware applications". Isn't
clustering supposed to be transparent to the application?
I read a line in "Server Clusters: Architectural Overview"
that said:
"Server clusters also provide the --> APPLICATION
INTERFACES <-- and tools needed to develop new cluster-
aware aaplications that can take advantage of the high
availability features of server clusters"
Thanks,
Todd
Hi
The biggest issue is when the cluster fails over from one node to another.
The client application must re-connect to the cluster again as the
connection will be broken when the failover occurs.
Any transaction that was running on behalf of the client would have been
rolled back and the application will have to re-submit it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
<anonymous@.discussions.microsoft.com> wrote in message
news:1db6401c4546b$89e3d460$a101280a@.phx.gbl...
> If a customer has a na application that accesses SQL
> server running on a single machine (Windows 2003 Server)
> and then decided to implement an active/passive server
> cluster with SQL Server Enterprise, does the application
> that accesses the database need to change? I am not sure
> what is meant by "cluster-aware applications". Isn't
> clustering supposed to be transparent to the application?
> I read a line in "Server Clusters: Architectural Overview"
> that said:
> "Server clusters also provide the --> APPLICATION
> INTERFACES <-- and tools needed to develop new cluster-
> aware aaplications that can take advantage of the high
> availability features of server clusters"
> Thanks,
> Todd
>
|||A cluster aware application is an application that will function on a
cluster and failover when necessary. As an example, a virtual SQL Server
2000 server is cluster aware iin that it will fail back and forth. By the
same token, Excel is not. If SQL Server 2000 and Excel are both running on
node 1 and node 1 crashes SQL Server will failover to node 2, but Excel
will not.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Cluster-aware Applications
===========================
An application is capable of being cluster-aware if it has the following characteristics:
* It uses TCP/IP as a network protocol.
* It maintains data in a configurable location.
* It supports transaction processing.
Most database applications, transaction processing applications, file and print server applications, and other groupware applications are capable of being made cluster-aware.
There are two types of cluster-aware applications:
* Applications that are managed as highly available cluster resources by a custom resource type. If you want your application to be highly available, to fail over, to benefit from customized failure detection
policies, or to be made available to clients on a virtual server, your application needs to be managed as a cluster resource. This means that in addition to any cluster-awareness you want to add to the application,
you will need to create a custom resource type to manage the application.
* Applications that interact with the cluster but are not cluster resources. Cluster Administrator is an example of such an application. This category also includes cluster-aware performance monitors, configuration
tools, setup applications, event handlers, and cluster management applications.
Cluster-Unaware Applications
===========================
The following features distinguish a cluster-unaware application:
* The application does not use the Server Cluster API. Therefore, it cannot discover information about the cluster environment, interact with cluster objects, detect that it is running in a cluster, or change its behavior
between clustered and non-clustered systems.
* If the application is managed as a cluster resource, it is managed as a Generic Application resource type or Generic Service resource type. These resource types provide very basic routines for failure
detection and application shutdown. Therefore, a cluster-unaware application might not be able to perform the initialization and cleanup tasks needed for it to be consistently available in the cluster.
Older applications are cluster-unaware. However, a cluster-unaware application can be made cluster-aware by creating resource types to manage the application. A custom resource type provides the
initialization, cleanup, and management routines specific to the needs of the application.
There is nothing inherently wrong with cluster-unaware applications. As long as they are functioning and highly available to cluster resources when managed as Generic Applications or Generic Services, there is
no need to make them cluster-aware. However, if an application does not start, stop, or failover consistently when managed by the generic types, it should be made cluster-aware.
Additional Information
======================
Platform SDK: Windows Clustering
http://msdn.microsoft.com/library/de...nformation.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
server running on a single machine (Windows 2003 Server)
and then decided to implement an active/passive server
cluster with SQL Server Enterprise, does the application
that accesses the database need to change? I am not sure
what is meant by "cluster-aware applications". Isn't
clustering supposed to be transparent to the application?
I read a line in "Server Clusters: Architectural Overview"
that said:
"Server clusters also provide the --> APPLICATION
INTERFACES <-- and tools needed to develop new cluster-
aware aaplications that can take advantage of the high
availability features of server clusters"
Thanks,
Todd
Hi
The biggest issue is when the cluster fails over from one node to another.
The client application must re-connect to the cluster again as the
connection will be broken when the failover occurs.
Any transaction that was running on behalf of the client would have been
rolled back and the application will have to re-submit it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
<anonymous@.discussions.microsoft.com> wrote in message
news:1db6401c4546b$89e3d460$a101280a@.phx.gbl...
> If a customer has a na application that accesses SQL
> server running on a single machine (Windows 2003 Server)
> and then decided to implement an active/passive server
> cluster with SQL Server Enterprise, does the application
> that accesses the database need to change? I am not sure
> what is meant by "cluster-aware applications". Isn't
> clustering supposed to be transparent to the application?
> I read a line in "Server Clusters: Architectural Overview"
> that said:
> "Server clusters also provide the --> APPLICATION
> INTERFACES <-- and tools needed to develop new cluster-
> aware aaplications that can take advantage of the high
> availability features of server clusters"
> Thanks,
> Todd
>
|||A cluster aware application is an application that will function on a
cluster and failover when necessary. As an example, a virtual SQL Server
2000 server is cluster aware iin that it will fail back and forth. By the
same token, Excel is not. If SQL Server 2000 and Excel are both running on
node 1 and node 1 crashes SQL Server will failover to node 2, but Excel
will not.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Cluster-aware Applications
===========================
An application is capable of being cluster-aware if it has the following characteristics:
* It uses TCP/IP as a network protocol.
* It maintains data in a configurable location.
* It supports transaction processing.
Most database applications, transaction processing applications, file and print server applications, and other groupware applications are capable of being made cluster-aware.
There are two types of cluster-aware applications:
* Applications that are managed as highly available cluster resources by a custom resource type. If you want your application to be highly available, to fail over, to benefit from customized failure detection
policies, or to be made available to clients on a virtual server, your application needs to be managed as a cluster resource. This means that in addition to any cluster-awareness you want to add to the application,
you will need to create a custom resource type to manage the application.
* Applications that interact with the cluster but are not cluster resources. Cluster Administrator is an example of such an application. This category also includes cluster-aware performance monitors, configuration
tools, setup applications, event handlers, and cluster management applications.
Cluster-Unaware Applications
===========================
The following features distinguish a cluster-unaware application:
* The application does not use the Server Cluster API. Therefore, it cannot discover information about the cluster environment, interact with cluster objects, detect that it is running in a cluster, or change its behavior
between clustered and non-clustered systems.
* If the application is managed as a cluster resource, it is managed as a Generic Application resource type or Generic Service resource type. These resource types provide very basic routines for failure
detection and application shutdown. Therefore, a cluster-unaware application might not be able to perform the initialization and cleanup tasks needed for it to be consistently available in the cluster.
Older applications are cluster-unaware. However, a cluster-unaware application can be made cluster-aware by creating resource types to manage the application. A custom resource type provides the
initialization, cleanup, and management routines specific to the needs of the application.
There is nothing inherently wrong with cluster-unaware applications. As long as they are functioning and highly available to cluster resources when managed as Generic Applications or Generic Services, there is
no need to make them cluster-aware. However, if an application does not start, stop, or failover consistently when managed by the generic types, it should be made cluster-aware.
Additional Information
======================
Platform SDK: Windows Clustering
http://msdn.microsoft.com/library/de...nformation.asp
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Subscribe to:
Posts (Atom)
