[SQL 2012] SQL Server 2012 Certification Study Guides |
- SQL Server 2012 Certification Study Guides
- Page life expectancy diving to sub-10 on a 128 GB server
- Downgrade Replication
| SQL Server 2012 Certification Study Guides Posted: 28 Feb 2013 01:51 AM PST I've finally embarked upon the certification path after (too many) years of broken resolutions.I'm choosing to go the study guide route rather than a boot camp or other course, as it allows me to also fit in the study during quiet periods in my current job.I'm starting from scratch, so the path is easy:70-461, 70-462 and 70-463 for MCSA followed by 70-464 and 70-465 for the Data Platform MSCE and (if I still have the will to live) 70-466 and 70-467 for the BI MCSEI have the Oreilly Study guides for the 3 MCSA exams and am forging my way through them.However, I was just browsing for study guides for the MSCE exams and am unable to find any.Does anyone have any details of study guides for 70-464, 70-465, 70-466 or 70-467 please?Ideally both printed and electronic format, but either would be fine.Thanks in advanceApologies - I should have posted this in the Career/Certification forum. |
| Page life expectancy diving to sub-10 on a 128 GB server Posted: 27 Feb 2013 09:36 AM PST Last weekend we migrated our primary ERP system from a Windows 2003, SQL 2008R2 server to a windows 2008R2, SQL 2012 server.The new servers are much beefier than the old ones, including an extra 32 gig of ram. The ERP database is ~500 gig, of which a good amount is audit data. On the old server I generally had page life expectancy values around 1000 or more for normal daily activity.On the new server I have been capturing perfmon stats for the past week and I see the PLE jumping all over the place. It climbs up into the several hundred but then suiddenly dives to ridiculously low values like 12 or even 7. The server usage profile has not changed, it's still the same users and applications doing the same things they were doing last week.The instance is set to have min 70 gig, max 110 gig allocated to SQL.The service account has lock pages in memory permission.Can anyone think of some setting I might have missed during migraiton, or some new option to be set in SQL2012 that I've overlooked, that could explain this? |
| Posted: 27 Feb 2013 02:02 PM PST Is possible to build a database replication from SQL 2012 to sql 2008? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment