<div>
Thanks very much to all. have added this to my knowledge base too.
</div>


<div>
<div class="content wysiwyg-content">
This one SQL database is becomming a bit large due to a large number of data.<br />
What are some of the high level things that I could do to enhance the performance ?<br />
<br />
Note that we do not have access to the application source codes that runs on top of the database, so optimising the queries and stored procs etc are out of the quesiton.<br />
<br />
Maybe adding an index to tables is an option if that helps . But need to know how as well.<br />
<br />
But again I would rather like to stay at the higher level, any suggestions ?
</div>
</div>


This one SQL database is becomming a bit large due to a large number of data.
What are some of the high level things that I could do to enhance the performance ?

Note that we do not have access to the application source codes that runs on top of the database, so optimising the queries and stored procs etc are out of the quesiton.

Maybe adding an index to tables is an option if that helps . But need to know how as well.

But again I would rather like to stay at the higher level, any suggestions ?

Thanks very much to all. have added this to my knowledge base too.

SQL Server 2000 performance tips needed

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Servers are computing devices that are similar to desktop computers in that they have the same basic components, but are significantly different in size, configuration and purpose. Servers are usually accessed over a network, and many run unattended, without a computer monitor, input device, audio hardware or USB interfaces. Many servers do not have a graphical user interface (GUI), and are configured and managed remotely. Servers typically include hardware redundancy such as dual power supplies, RAID disk systems, and ECC memory, along with extensive pre-boot memory testing and verification. Critical components might be hot swappable, and to guard against overheating, servers might have more powerful fans or use water cooling.