473,702 Members | 2,381 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Slow SQL performance with Maximizer Enterprise 8.0 SQL

Hi to all,

I've recently installed SQL Server 2000 on Dell Power Edge 1600sc with
dual processor (2.8ghz) and 1 gig of ram, to use a CRM application
(Maximizer Enterprise 8.0)and since we make the install every time a
user is trying to access data it take about 5 to 10 second to see the
requested data. The performance of the SQL server less than the
pervise version of Maximizer.

I've made a typical install of SQL server 2000 and SP3.
Analysis Services as been installed too.

I've seen a strange memory workload this week, the used memory was
about 740,390 kb, from my knowledge of SQL, i think this is very not
normal.

Any help will be welcome

Thanks in advance

V. Mesiti
Network Admin
Renmark Financial
Jul 20 '05 #1
1 1927
Vincent Mesiti, Network Admin (vm*****@renmar kfinancial.com) writes:
I've recently installed SQL Server 2000 on Dell Power Edge 1600sc with
dual processor (2.8ghz) and 1 gig of ram, to use a CRM application
(Maximizer Enterprise 8.0)and since we make the install every time a
user is trying to access data it take about 5 to 10 second to see the
requested data. The performance of the SQL server less than the
pervise version of Maximizer.

I've made a typical install of SQL server 2000 and SP3.
Analysis Services as been installed too.
Without any knowledge about Maximizer Enterprise, it is very difficult
to say. There are of course a couple of standard suggestions:

o Make sure that statistics are up to date.
o Make sure that your tables are not fragmented.
o Check for blocking.
o Use Profiler to catch long-running queries and to review query plans.
o Add indexes to improve performance.

But in the end, I would suggest that you should contact the vendor about
the issue.
I've seen a strange memory workload this week, the used memory was
about 740,390 kb, from my knowledge of SQL, i think this is very not
normal.


That is perfectly normal. SQL Server is designed to grab as much memory
it can. The reason for that is that the more data SQL Server can hold
in cache, the less does it have to read from disk, and the faster the
response time will be. If there are other programs competing for memory
SQL Server will yield memory.

Now, if you are not used to see this memory consumption, it may be that
previously the queries were focused on a such a small part of the database
that SQL Server did not need much cache. If this have changed now, it may
be due to queries that now requires a table scan for some reason. So
a higher memory can be an indication that there are poor querly plans.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
6151
by: Adam Ryan | last post by:
Hi, I am seeing very slow connections from some client enterprise managers to server. Even at server level it takes 1 minute or less to open a database. I have adjusted some of the memory for the SQL server, but there are only about 60 Dbs on the server, totalling about 2 GBs. CPU is very low at all times, 1 GB of ram, p3 1.4Ghz. SQL 2k.
1
1665
by: Thomas Richards | last post by:
Hi, I have a table with about 70k rows. When I use open table --> return all rows and then edit a field Enterprise Manager then says it has to return the entire result set for the update to take place. This can take a long time and makes editing data a slow process. Is there any way to get Enterprise Manager just to update the one row?? Thanks Tom
1
1389
by: John Morgan | last post by:
I am using a dial up connection to the Internet and to an online SQL Server database. I have a problem in that when I use Enterprise Manager to access even my local server , or even, it appears, when it is just open with no connection to any SQL Server, I experience very slow data transfer over my normal dial up connection. I am reasonably sure it is Enterprise Manager causing the problem as when I close it and redial I have an...
16
21317
by: mamo74 | last post by:
Hello. I am administering a SQL Server (Enterprise Edition on Windows 2003) from some month and can't understand what is going on in the latest week (when the db grow a lot). The DB is around 250G, and has one table with 1 billion rows. It is performing in a decent way, but can't understand why a particolar table has strong performance problem.
0
1163
by: schmurgon | last post by:
Debugging my 1.1 framework ASP.NET web application (which talks to a ..NET Web Service on the same machine) has become extremely slow since installing VS 2005 and / or SQL Server 2005. It takes between 2mins to 4 mins to step into the first web page! Watching the output window, the first 15 to 20 assemblies load fast, but then performance gradually decreases to the point where a single line (indicating a loaded assembly in the Temporary...
0
1887
by: gralet | last post by:
Hi, I'm using the Microsoft Enterprise Library in my ASP .NET 1.1 application, but only the following app blocks: Microsoft.Practices.Enterpriselibrary.Common Microsoft.Practices.Enterpriselibrary.Configuration Microsoft.Practices.Enterpriselibrary.ExceptionHandling Microsoft.Practices.Enterpriselibrary.ExceptionHandling.Logging Microsoft.Practices.Enterpriselibrary.Logging I installed my app in a Windows 2000 Server, and I also...
23
14031
by: Nishant Saini | last post by:
Dear All, We have a database which contains many tables which have millions of records. When We attach the database with MS SQL Server 2005 Standard Edition Server and run some queries (having joins, filters etc.) then they take very long time to execute while when We execute same queries on Enterprise Edition then they run 10 times faster than on standard edition. Our database does not use any features which are present in Enterprise
13
3448
by: eighthman11 | last post by:
using Access 2003 and sql server version 8.0 Hey everyone. Created a text box where the user types in an Inventory number and it takes them to that inventory number on the contimuous form. The form is based on a link table to sql server. Here is the code: Dim rst As DAO.Recordset Dim InventoryItem As String InventoryItem = "'" & "TextBoxValue" & "'"
6
6079
by: binky | last post by:
Good afternoon folks, I have a performance question if anybody might have suggestions. Functionally, everything i'm about to describe works as intended. The only problem I'm having is speed. Assume: 1) Using MS Access 2003 in an ADP project, SQL Server 2000 Enterprise backend 2) Main form is populated by a stored procedure, which works flawlessly 3) There is a listbox on the form that will display matching records based on a key...
0
8739
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...
1
8983
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8940
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
7831
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
6575
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
4412
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
4667
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3107
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
2
2402
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.