473,321 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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 1915
Vincent Mesiti, Network Admin (vm*****@renmarkfinancial.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****@sommarskog.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
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...
1
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...
1
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...
16
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...
0
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...
0
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...
23
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...
13
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...
6
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. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.