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

Building a new server Expand / Collapse
Author
Message
Posted Tuesday, June 4, 2013 12:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 2:09 PM
Points: 5, Visits: 53
OK, I am in charge of specifying our new SQL server, our server now is 5 years old and we are seeing some performance issues. We are a small company and I am as close to a DBA as we have so bear with me.
A few questions keep coming up…
1. Physical or virtual? All of our servers now are virtual expect our SQL server.
2. Should the report server be on a separate server than the database?
3. We are running Backup Exec on our database server, is this ok?

Our current server is as follows, do you see any issues with this setup?
Dell Power Edge
• Windows server 2008 r2 sp1
• SQL 2008 r2 Standard
• 24 gb RAM
• 2x 4 core, Intel Xeon X5365 300GHz
• A single Raid 5 (4 SCSI 15000 rpm drives)

Thank you.


Also we are wanting to upgrade to SQL 2012
Post #1459903
Posted Wednesday, June 5, 2013 4:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 31, 2014 8:39 PM
Points: 1, Visits: 48
Some information about the size of your database would probably help as well. Also, what kind of performance issues are you experiencing? It could just as simple as a job hogging all the resources on your server. It is also a good idea to have the database on its own server just in case another application starts using all the resources on the server, but I can understand if you do not have enough funds to do so.
Post #1460493
Posted Thursday, June 6, 2013 5:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 2:09 PM
Points: 5, Visits: 53
We have several databases but the main database is just under 10 gig. The issue i am seeing is when users are using rendering reports or other peak time activities the processor stays high, sometimes 100% usage. We use a custom written software that I wrote and i have removed a bunch of the sql processing to c# on the client machine but still see high processor usage and its always sql server using it, this is mainly using task manager. Also there are times that in SSMS a simple select statement can take seconds to run.
Post #1460627
Posted Thursday, June 6, 2013 6:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:54 AM
Points: 6,813, Visits: 14,028
Are you the adminstrator of the SQL server instance, Mike?

“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1460658
Posted Thursday, June 6, 2013 6:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 2:09 PM
Points: 5, Visits: 53
yes i am.
Post #1460660
Posted Thursday, June 6, 2013 7:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:45 AM
Points: 1,104, Visits: 696
Mike Martin (6/4/2013)

2. Should the report server be on a separate server than the database?


In case of separate servers you will need additional MS SQL Server license.
Post #1460688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse