Thursday, April 11, 2013

[SQL 2012] NUMA and PLE on SQL Server 2012

[SQL 2012] NUMA and PLE on SQL Server 2012

NUMA and PLE on SQL Server 2012

Posted: 04 Feb 2013 11:26 PM PST

I've read both Paul and Jonathan's blogs regarding this issue (http://www.sqlskills.com/blogs/paul/page-life-expectancy-isnt-what-you-think/) and started looking at the PLE counters for each individual NUMA node. I can't seem to wrap my head around why there is such a widespread discrepancy between the NUMA nodes. We are running SQL Server 2012 Enterprise Core. Any insight would be greatly appreciated.Thanks,Tommy[url=https://skydrive.live.com/redir?resid=EB98D18648791013!7197&authkey=!AN6DKRDzgyJlarU]https://skydrive.live.com/redir?resid=EB98D18648791013!7197&authkey=!AN6DKRDzgyJlarU[/url][img]https://skydrive.live.com/redir?resid=EB98D18648791013!7197&authkey=!AN6DKRDzgyJlarU[/img]

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?

Replication to Oracle 11g, Help!!!

Posted: 10 Apr 2013 02:10 PM PDT

I would like to replicate transaction changes from sql server (2005 & 2012) to oracle 11g, I want the transaction changes (insert, update, delete) on tables to replicate to oracle tables fast, what kind of tools in sql server can I use? How can I just use the transaction log from sql server and apply the delta changes to oracle database, thanks?

SQL Server 2012 Import Export Wizard (32bit) - xlsb file format ????

Posted: 10 Apr 2013 07:03 AM PDT

Hi Really could use some guidance here... I have a very large xlsb file(s) which I need to import So I am using SQL Server 2012 Import Export Wizard (32 bit)1.Choose a Data SourceI set the Data Source : Excel from the dropdownThen browse to my xlsb file which automatically changes the Excel version dropdown to Microsoft Excel 2007Then the Wizard has a little think and comes back with a message saying[b]Operation could not be completeExternal Table is not in the expected format [/b]Is there something else that I am supposed to do... cant seem to find anyone with the same issue online:crazy:

Powershell 3.0 provider?

Posted: 10 Apr 2013 05:49 AM PDT

When running a Powershell step in a SQL Agent job, the environment is 2.0. Is there a new 3.0 provider for SQL Server? Seems strange that PS 3.0 wasn't either shipped with SQL 2012 or at least that there wasn't a way to update it with a new provider when 3.0 became generally available.I know you can run a cmdexec step and execute a PS command shell there but that's kind of a kludge in my book.

Very high CPU usage when processing a database in SSAS 2012 (process msmdsrv)

Posted: 10 Apr 2013 05:00 AM PDT

Hi,Is there a way to limit the CPU usage of a process? When we process one of our SSAS database, the process (msmdsrv) the CPU is spiking to 85-90%, causing the rest of the processes to be unresponsive, this include one of our SQL 2012 server (on the same box).I had a look at WSRM, but unfortunately this is doing the opposite I need to do for CPU. The target is the percent of available CPU bandwidth that is guaranteed as a minimum to the process group.Any help will be appreciated.Rem
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog