Thursday, June 20, 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]

Deploying report to server

Posted: 20 Jun 2013 01:26 AM PDT

Hi, I'd like some advise on deploying a report to a server where the datasource is on a separate server.I'm currently creating the report on my local machine, which is using SQL 2012 Data Tools. The database is hosted on a SQL 2005 Server. I'm deploying to a SQL 2012 Server. All on same domain, etc.I'm currently getting an error when accessing the report via a browser: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errorsWhen I access the log I see:library!ReportServer_0-8!5bec!06/20/2013-15:17:07:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.I've previously successfully made reports where the database was on the same server as the reporting server, but never tried it this way. Any tips?

RESTORE DATABASE is terminating abnormally.

Posted: 19 Jun 2013 09:28 PM PDT

Hi there, I have a database called - Oneserve_Stage, which for some reason is showing as (Restoring...) next to the database.How can I get this back to a normal state.When I run the following TSQL - USE masterRESTORE DATABASE [Oneserve_Stage] FROM DISK = N'\\mhsvi-mgmt03\oneserve_DW\ExportFromOneserve\MHS_DataCut_PROD.BAK' WITH FILE = 1, RESTART, RECOVERYI get the following errors - Msg 3183, Level 16, State 2, Line 2RESTORE detected an error on page (0:0) in database "Oneserve_Stage" as read from the backup set.Msg 3013, Level 16, State 1, Line 2RESTORE DATABASE is terminating abnormally.I have no idea why this database is now showing like this? Any help will be appreciated.Thanks

Any way to display multiple rows of tabs?

Posted: 19 Jun 2013 11:55 PM PDT

SSMS 2012: when you open up many sql files in the IDE, it starts hiding some tabs and you have to click on the drop down at the right to navigate to the tab you want. Is there a way to make it display more than one row of tabs, so that tabs are not hidden and always displayed?

SSRS 2012 color theme

Posted: 19 Jun 2013 07:14 AM PDT

Can it be changed? Not the text editor window and fonts, but rather the toolbars and empty environment colors. I hate the default blue color.

SQL Server Management Studio and TFS

Posted: 19 Jun 2013 10:40 PM PDT

Hello, I am running SSMS 2012 SP1 and Visual Studio 2012 on my computer and Team Foundation Server works fine within VS but not SSMS. Under Tools>Options>Source Control in SSMS, there are no plug-ins listed, but they are in VS. Any ideas on what I need to do to make TFS work with SSMS?

No comments:

Post a Comment

Search This Blog