Wednesday, June 5, 2013

[SQL 2012] mutli instance sql server 2012

[SQL 2012] mutli instance sql server 2012

mutli instance sql server 2012

Posted: 05 Jun 2013 01:41 AM PDT

I have a big box with sql 2012 standard edition. 128 gig of ram. Since there is a 64 gig memory limit on 2012 std edition, I was thinking of firing up 2 instances (this is an active/passive cluster). and assigning 64 gig to each instance. The server is licensed per proc so for the license side I think I am ok, from a technical perspective does anyone see an issue?

sql server 2012 memory limit

Posted: 04 Jun 2013 06:23 AM PDT

My bad it looks like sql 2012 standard edition only can use 64 gig of memory (change from 2008) 2 ?, I have seen some people post this is not true, anyone else seen that. Also I have an active passive cluster, since my server has 256 Gig of Ram could I create another active/passive cluster and set aside 64 gig for this and 64 gig for the existing cluster?

create report with SSRS from an SSAS cube

Posted: 04 Jun 2013 09:23 PM PDT

hello everybodyi have to create a report from my cube , but i found some difficulties when i create my cube i have to add some measure manualy even if they exists on my DSV and when i do it i have ' USAGE ' ( sum , count , acount , aggregation ... ) i dont need this usage my measures are juste ID who i have to analyse them by dimensions !

Building a new server

Posted: 04 Jun 2013 05:43 AM PDT

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
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog