Re: Shared Memory from older app SQL Server 2005

Sorry, I missed it. That engine should be able to handle the Library of Congress book index in its idle time. I expect you need to look at what the application is trying to do. Turn on the profiler and watch for awhile. (Yes, this will slow it down considerably). The profile can be saved to a file that can be fed to the analysis tools that can tell you which indexes are working and which are needed. We've seen big honking databases (spread over a dozen systems) that did not have ANY indexes. Consider that SQL Server might not be configured (or configurable) to address that much RAM. It might not be using more than 4GB. Pass this thread over to the SQL Server Programming newsgroup... but CC this list so we can watch what they say.

I would also bring in Kimberly Tripp to do a performance analysis.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

<djouungk@xxxxxxxxxxx> wrote in message news:1187029034.873601.311900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Yeah I did:

> Like I said, it is a horribly written program. We have a Quad core
> 2.66 GHz CPU with 16GB of ram. We are using Windows 2003 x64 R2
> Enterprise with SQL 2005 x64 Std. (Test box atm, SQL Server is all
> that's installed)

16 GB of RAM, and only server and SQL Server is running. This server
is not being used at all at the moment for anything else.

This was written in Gupta's Centura Runtime. It's an ERP system.

Thanks,
Doug


.

Relevant Pages

  • Re: What are OleDbParameter names with Original_ prefix?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Since the table has a primary key column, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Transaction
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Client transactions put too much schema-dependent, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Performance problems with OracleDataReader
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... referencing the columns by ordinal is far faster than using strings. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Very slow
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.ce)
  • Re: ADO.NET Transaction
    ... The SqlBulkCopy class can take anything you can expose with a DataReader and send it to SQL Server in a single high-speed operation. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Client transactions put too much schema-dependent, ...
    (microsoft.public.dotnet.framework.adonet)