Thursday, October 3, 2013

[SQL 2012] Huge Increase in Logical Reads for 17 Hour Period

[SQL 2012] Huge Increase in Logical Reads for 17 Hour Period

Huge Increase in Logical Reads for 17 Hour Period

Posted: 03 Oct 2013 01:46 AM PDT

We have recently implemented Dynamics CRM and have been working to performance tune all aspects of the product. Yesterday we started getting calls related to slow performance. I installed a performance analyzer toolset named DynamicsPerf (http://archive.msdn.microsoft.com/DynamicsPerf). This tools captures data from the DMVs every 2 hours and stores it in a database.While analyzing this issue I noticed that logical reads in this timeframe were through the roof. A query which usually averages 1k - 2k reads was averaging 1.4 million reads. This was happening with a number of different entities.Looking at the data DyamicsPerf captured (very small subset attached), it looks like the same statements and executions plans were used before, during, and after this timeframe.Any insight into what could cause this type of behavior would be much appreciated.Thanks,Sam

Pass data from SSRS report result set to Webform

Posted: 02 Oct 2013 07:42 AM PDT

This is my first post here so good day to all. Let me give you a background on the item I need help with.Where I am as we speak (as simplified an explanation as I can give):Webform1 has a textbox1 and button1 control on it.Upon clicking button1 it that captures the textbox1 data and passes the captured value to Webform2 Upon loading Webform2 the parameter is passed to the reportviewer control where the report displays queried result.All of the above is already in place.What I want to know:Is it possible to have the SSRS report contain links within the results of the report that can be passed back to a Webform so that it can be used to populate textbox controls on a third webpage? Sort of like a drillthrough but not.i.e. Webform with Reportviewer control that has a SSRS report result which returns and ID column. Each piece of data in the ID column has a link that passes the piece of data as a parameter to Webform3. Webform3 takes the parameter and passes it to a SQL stored proc which returns the data to load textbox controls on Webform3.Can this be done?Clear as mud? Any and all help is much appreciated!!!

SQL Server version

Posted: 03 Oct 2013 02:32 AM PDT

When I run SELECT @@VERSION on SSMS of the instance I got the following info.Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)I have another instance and when I run the same command I see the following info.Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)Does it mean the first one is not an eval version and it'a licensed version?Is there any other way to confirm if an instance is a licensed version or not?Thanks.

Book Reviews

Posted: 03 Oct 2013 12:27 AM PDT

Wouldn't it be a great idea to have forum members give their reviews of the book that has been featured in the latest newsletter? I honestly do not know what to make of so many "Amazon" type reviews, some of which are hyper-critical of the author to an unacceptable degree, yet others who sound like "professional" reviewers who "review" anything by skimming pages and rehashing table of contents. Much like that old adage that says don't judge a book by its covers, I'm tempted to say don't judge a book by its reviews. To be fair, in between these, there are a few helpful reviews. I'm sure that members of this forum who are mainly practitioners in the field will have many useful, helpful comments, on the books featured and newbies like me can profit greatly from their reviews.Anyone else for the idea?

SQL 2012 Import wizard VERY slow - what to do?

Posted: 02 Oct 2013 08:16 AM PDT

I was using the SQL 2012 import wizard to double the size of my 80k record table. It has been stuck on the same '1160 rows transferred message' for three hours, which is weird as it normally only takes a couple of minutes to copy the whole table. In the Task Manager it is still in 'running' status. Should i just let it run, or can i stop it using a command, without the DB going into 'suspect', 'emergency' or some other weird state? Will 'take offline' and go back 'online' or 'detach' then 'attach' safely work?Thanks

openquery and DBCC

Posted: 02 Oct 2013 09:01 PM PDT

Hello.This queryselect * from openquery([ServerName],'exec(''SET FMTONLY OFF; dbcc page(20,1,192963 ,0) with tableresults'')')works fine in SQL SERVER 2008R2But in SQL SERVER 2012, the next message:Mens 11527, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1The metadata could not be determined because statement 'dbcc page(20,1,192963 ,0) with tableresults' does not support metadata discovery.Why?There is other way to determine the object with this page number?Thanks.

Find value of cell from header name and row name (like going down and across)

Posted: 02 Oct 2013 08:38 PM PDT

what I want is the value of cell just like where x meets y, going down and across what is the value in that cell.Thank you for your time

Support of JET OLEDB

Posted: 02 Oct 2013 06:51 AM PDT

All,We are planning to upgrade from SQL Server 2005 to SQL Server 2012.1. We have many SSIS packages. What is the best apporach to migrate them?2. We have many SSIS packages using JET OLEDB provider. How to make this work in SQL 2012?Thanks in advance.Regards,

Launch SSMS from command prompt

Posted: 02 Oct 2013 04:15 AM PDT

Hi,How do we launch 2012 SSMS from command prompt? I was using ssms.exe to launch 2008 SSMS also googled and found we can use ssms.exe for 2012 ssms also. But in my system both 2008 and 2012 installed. But when I use ssme.exe the 2008 ssms is opening. Even I tried with the the instance name with -S switch. So it is opening in 2008 ssms.

Missing OraOLEDB provider

Posted: 29 Jul 2013 06:05 AM PDT

I need to be able to set up Linked Servers on our SQL Server 2012 Server. When I try to set up a new Linked server... I do not see the Oracle provider. I installed 64 bit Oracle client.... no go. I then installed 32 bit Oracle client in addition to 64 bit.... no go. I tried a Regedit hack I found on Google.... no go. I rebooted the server after each of the above attempts. Has anyone found a solution to this issue? Thank you in advance.Charlie

BIDS vs SSDT

Posted: 02 Oct 2013 05:45 AM PDT

Hi,Simple question.We already develop with BIDS for SQL server 2008. We recently upgrade th PC to Visual Studio 2012 for our developper but our server still with SQL 2008.Could it be possible to use SSDT for developpement instead using sql 2008 on the server?Not sure if it's clear? I wish :)Steve
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog