Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by sqltekmember
-
Server Capacity
The data growth is around 30-35% per year. This prompts to take the medium-sized server route. To answer MrDennys question, the dell server holds upto 8 drives. Thank you for your valuable suggestions and inputs. I will discuss with our System Admin and share the thoughts. Hopefully the new...- sqltekmember
- Post #10
- Forum: Microsoft SQL Server: Setup and Administration
-
Server Capacity
Thanks CatAdmin and mrDenny for your help. Yes our server is Hyperthreaded. It has 2 physical processors. Raid 1 config with 26 Gig Hard Disk space. The Database(mdf) and LogFiles(ldf) are kept at the same location in the machine. Our application is more of an OLTP system and as mentioned...- sqltekmember
- Post #7
- Forum: Microsoft SQL Server: Setup and Administration
-
Server Capacity
Thanks for the Info. I ran the perfmon on our Database server and found the following. Under OFF Peak Conditions: Transactions/Sec - 10 Memory - Page Reads/Sec: 0.3 - Buffer Cache Hit Ratio: 99.XX I/O Counter - Disk Reads/sec: 20 - Disk writes/sec: 5 - Avg. disk...- sqltekmember
- Post #4
- Forum: Microsoft SQL Server: Setup and Administration
-
Server Capacity
Hello All, I am in the process of upgrading our DataBase hardware to a newer system. I have very little experience in capacity planning. I was wondering if I can get a ballbark estimate of the server needs based on our DB size. Number of Databases - 130 (all of varying size from 10MB to 1.5 GB)...- sqltekmember
- Thread
- Replies: 10
- Forum: Microsoft SQL Server: Setup and Administration
