Timofey's questions -server

Timofey

Asked: 2011-07-27 01:01:45 +0800 CST

Server Configuration

Recently we have got problems with performance in SQL Server 2008 Enterprise.

One idea to solve it is to scale up, i.e. improve hardware of the server.

SQL Server 2008 has 2 instances that are running under 64-bit Windows Server 2008 Enterprise.

The configuration of the server is the following:

CPU: Quad-code AMD Opteron™ Processor 2356, 2.51 GHz (2 Processors). CPU is normally 20-35% in use if not under stress, and 80-90% if under stress.
RAM: 30 G, 24,6 G for both instances of SQL Server.

How do you think the configuration of the server is weak enough to be improved?

I wanted to have a sensation which configurations are in use by other companies, and if you know yours you might also post it. Thank you.

Timofey

Asked: 2011-01-25 02:40:50 +0800 CST

Imagine we have a table:

create table MYTABLE (
 id int IDENTITY(1,1)
,name varchar(10)
)

We have to insert a lot of rows into the table.

Does anybody know what will happen when a generated identity value oversteps a maximal integer value (2^32-1)?