Capacity Planning For SQL Server 2005

Hi,

I need to do a capacity plan for a existing SQL Server, which is currently having below Server Configuration.

• 64 Bit Operating System
• 8 GB Memory
• Windows Server 2008 SP1
• 2 Node Cluster Environment
• Peak hours Physical Memory and Processor Utilization go up to 40-60-80%.
• SQL Server 2005 Enterprises Edition
• DB Size is 350 GB, which is the only user DB resides on this box.

Now the current/Expected utilization of this DB is
Data rate calculations

Logs generated

Daily (GB)

Within working hours*

Data rate (MB per minute)

Current

50

48

68

Expected with 80000 users

143

137

195

I have tested various scenarios to determine the appropriate log file size and following are the results

Log File Size Inc

Processing speed (MB per minute)

2 MB

127

5 MB

261

10 MB

269

20 MB

128

I further ran some tests to find out the processing speed if a report is generated simultaneously

Log File Size

Report Generated Simultaneously

Processing speed (MB per minute)

10 MB

No

269

10 MB

Yes

201

So now as per the existing utilization, how can I do a capacity plan to upgrade the Hardware like RAM/CPU for the expected requirement, so in future the system should not have any issue when the expected requirement are set from application side to process the data.

Thanks in Advance

Rahul

I think tables are making confusion so I am making a manual entry for that.

Table 1
Logs generated Daily (GB)Within working hours*Data rate (MB per minute)
Current 50 48 68
Expected with 80000 users 143 137 195

Table 2
Log File Size Processing speed (MB per minute)
2 MB 127
5 MB 261
10 MB 269
20 MB 128

Table 3

Log File SizeReport Generated Simultaneously Processing speed (MB per minute)
10 MB No 269
10 MB Yes 201