Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Server Review Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 6:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 7:46 AM
Points: 190, Visits: 474
What are the things we need to consider for reviewing a windows server keeping SQL server as our point of interest.
Post #1437864
Posted Wednesday, April 3, 2013 7:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 1,272, Visits: 2,794
First of all what do you mean, capacity for existing?, capacity planning for new? Also, what version of Windows, what version of SQL Server?


Post #1438311
Posted Wednesday, April 3, 2013 7:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 7:46 AM
Points: 190, Visits: 474
Capacity for existing
Post #1438318
Posted Wednesday, April 3, 2013 7:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 7:46 AM
Points: 190, Visits: 474
windows 2008 r2 and sql 2008r2
Post #1438319
Posted Wednesday, April 3, 2013 7:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:56 AM
Points: 1,272, Visits: 2,794
You can view Task Manager for CPU usage and there are some good monitoring tools to graph that over time to see if you are maxing the box at high usage parts of the day/night. Memory, the more the better, (if you are 64 bit)..... Database sizing, only you will know what dbs you have in SQL Server and know the growth pattern to know if you will need more space over then next 12 months to 4 years. You can run profiler to capture longer running SQL statements to see if you can add tuning indexes to make it run more efficiently.


Post #1438322
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse