473,699 Members | 2,386 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

odbc memory use

1 New Member
We recently deployed an upgraded application on all new hardware. The infrastructure performed exceptionally well as we monitored cpu & memory use. After 4 days my application team advised me they needed to roll back the odbc driver on the servers. The performance on the servers is now almost as bad as it was before the upgrade. The rollback process took maybe 5 minutes per server. Supposedly that's all they did to the servers. We went from Intel x32 dual processor blade servers w/4gb ram running Win2k3 standard to AMD dual core blades w/8gb ram running Win2k3 enterprise. These things ran like a champ for almost a week. I saw upwards of 150users per server not even touch the paging file. After the rollback with 45 users I'm seeing 26gb of page file being used. Any thoughts? I'm trying to work with the application team to troubleshoot this and they claim they had to rollback because of some data problems they were having with the newest odbc driver. I've seen some references to memory vs disk based tables related to odbc and am wondering if this is our issue. The newest odbc was somehow using disk based tables when users logged in, thereby not using as much ram, hence page file space. The rollback driver is using memory based tables so is gobbling up as much ram, and paging file space as possible. Any thoughts would be appreciated. This is a group of 17 identical front end servers in a Citrix / terminal services environment.

Thank you,
Sep 11 '06 #1
0 1246

Sign in to post your reply or Sign up for a free account.

Similar topics

10
2869
by: Kim Petersen | last post by:
Regarding ODBC usage in Python... it seems to me that there is a couple of ways to use odbc from python, one of these is the MX version - now that one has a pretty steep licence cost (imho). So now comes my question (from reading this group quite a bit): - what is the basic reason for using MX versus the others? - why do you (newsgroup) seem to think that this package is the preferred one? - in case above is incorrect - what package...
13
4932
by: Graham | last post by:
I need a SQL Server or ODBC package for Python. Can anyone help please? Have search the Python packages under Database and there is no reference to either SQL Server or ODBC. Thanks Graham
4
7909
by: Kong Li | last post by:
Environments: 1. WinXP SP1, MDAC 2.7 SP1 (Microsoft ODBC for Oracle is 2.573.9030.0), Oracle client 9.2.0.1. 2. Win2000 SP4, MDAC 2.7 SP1 (Microsoft ODBC for Oracle is 2.573.9030.0), Oracle client 9.2.0.1. 3. Win2000 SP4, MDAC 2.8 (Microsoft ODBC for Oracle is 2.573.1022.0), Oracle client 9.2.0.1. I have a simple program calling SQLDriverConnect (not OLEDB, not ADO, but ODBC) to an Oracle server 9.2, and then disconnect. The value of
1
6722
by: M. Oakley | last post by:
We are using ODBC connection pooling with SQL Server 2000 v5 on Win 2000 v5 sp4. Each time we get a connection, SQLConnect, we see the memory usage go up, about 52K. When we return the connection to the pool, SQLDisconnect, and after the time that the connection remains in pool expires we see the memory usage drop by about 28K. Our basic steps for a select are: SQLAllocHandle(SQL_HANDLE_DBC, hGblEnv, &hdbc);
3
10241
by: mike | last post by:
trying the following code to test SQL connection to MS SQL server using machine DNS name. receiving errors: undefined reference to 'SQLAllocEnv@4' undefined reference to 'SQLAllocConnect@8' (etc. for all SQL function calls in the code) using Dev-C++ 4.9.9.2 and the latest mingw WindowsAPI package (where the sql header files are)
3
5580
by: Ian | last post by:
We are currently experiencing problems with our Access XP database. We are using access as the front-end and are connecting to Oracle 7.3 via ODBC. Our users are running Win 98 and Win Xp. We are currently using Oracle73 drivers ver:1.15.03.01 File: SQ032.73.dll Date:18/06/1996. The Problem, I can re-link the Oracle tables and open them within access, However the tables take around a minute to open. When I try to run a query I receive...
4
3570
by: Dave | last post by:
Hey guys, I have an ODBC problem that has me stumped. I wrote a VBA script to run in Microsoft Excel that pulls data out of an application using that application's ODBC driver and puts it into Excel. I am trying to translate the same program over to Microsoft Access and I ran into a problem. Access locks up if the data I am querying for is not present in the database. To retrieve data from the database of the application, my Excel...
2
7790
by: bert.medley | last post by:
I have a problem that I can distill down to the following. 1/ A Visual C++ 6.0 program connects to a MS Access database using an ODBC connection and sleeps for a long time. The connection takes all defaults and uses CDatabase::useCursorLib in the OpenEx command. 2/ The database is well over 400MB large with over 200 tables and is compacted. 3/ Another process starts a winzip on that database that takes about 45
0
1097
by: bert.medley | last post by:
I have a problem that I can distill down to the following. 1/ A Visual C++ 6.0 program connects to a MS Access database using an ODBC connection and sleeps for a long time. The connection takes all defaults and uses CDatabase::useCursorLib in the OpenEx command. 2/ The database is well over 400MB large with over 200 tables and is compacted.
0
8685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9032
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8880
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7745
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6532
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4374
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3054
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.