.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Migrating from 2005 to 2008R2 - now 10x slower

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
I host a RS2005 instance on a Win2003 server (2gb ram; 3ghz xeon cpu) which is performing quite nicely. I'm now migrating to a RS2008R2 instance on Win2008R2 server (12GB ram; Xeon 5110, 64bit) and hoping for a big performance increase. Instead I see the reverse. It's a 5-10second delay every time I select an option in the Report Manager. Similarly, on demand reports are taking 15 seconds instead of 3 seconds. The Win2008R2 server is a brand new machine, freshly installed with OS and SQL. I have a test Win2008R2 server inhouse (much lower specs) which runs fine. What can I try? The hosting provider has currently disabled McAfee antivirus, with no noticeable difference. Any help would be MUCH appreciated.


View Complete Post


More Related Resource Links

DTExec is MUCH slower that just running my package in Debug mode in BIDS 2005

  
I am using BIDS / SSIS 2005.  I have a large package that runs very smoothly and fairly quickly when run in debug-mode through BIDS.  When I actually deploy the package to SSIS and execute it using either DTExec or DTExecUI it is WAAAAYYY slower than when run from the development environment.  So slow that I become convinced it is hanging on steps that execute very very quickly in BIDS.  I have read this thread -> http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5585fa13-dd15-4406-9d4a-e993f2af5929 which has not helped. I understand that DTExec would be faster than DTExecUI because the former does not have to deal with the GUI component but I would have expected both (and especially DTExec) to be faster than running in debug from BIDS. I realize I am not providing a ton of detail here, problem is I just don't know where to start... any advice on what I should be looking at to improve package execution through DTExec and / or DTExecUI would be greatly appreciated.  Why would DTExec be so much slower than BIDS Debug??? Thanks in advance.. - Charles

Problem Installing SQL 2005 Enterprise on Server 2008R2 Enterprise???

  
I am trying to install SQL Server 2005 Enterprise onto a new WinServer Enterprise 2008R2 box.  I am using my MSDN disk that contains the various flavors of SQL Server 2005.  When I select to install Enterprise (64 bit) version all that is available for installation are the client tools, no server tools.  When I install the Standard version, the server tools are available. Is there a problem installing SQL 2005 Enterprise on WinServer Enterprise 2008R2???

SSRS 2005 to 2008R2 custom code migration issue

  

We have an SSRS 2005 report that we upgraded to 2008R2 with custom code in the report properties code tab that no longer works.  We checked permission setting in the report server config files, checked if the data set was passig nulls and it is not, looked to see if we ignored the error if the report would render the correct value anyway despite the error and it did not, tried different code variations and referencing different system libraries without luck....we are truly baffled.  The only thing that does work is setting the total to 0 and removing the loop through the jsColl to compute the total.  Here is the code that used to work on 2005.  Any ideas why it does not work on 2008R2?  We call it in an expression =Code.getTotal()

Public

 

jsColl As Microsoft.VisualBasic.Collection

 

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

Issues with Migrating SSRS 2005 to SSRS 2008

  

Hi All,

Our Team working on migration of reports. But in our SSRS 2005 reports RDL's they added small piece of code(Highlighted)  in 
eg:

********************************************************************************

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
    <DataSources>
        <DataSource Name="xyz">
            <ConnectionProperties>
                <DataProvider>SQL</DataProvider>
                <ConnectString>="server=" + Parameters!ServerName.Value.ToString() + "; database=" + Parameters!Database.Value.ToString() + ";"</ConnectString>
            </ConnectionProperties>
        </DataSource>
    </DataSources>
  

Migrating Jobs: SQL 2005 32bit > SQL 2005 64bit

  

I am trying to migrate jobs between SQL Server 2005 32 bit to SQL Server 2005 64bit.  I follow the steps in the KB Article to copy a job by scripting it and then running the SQL against the new server.  The query executes fine, but it only creates a skeleton of the job with nothing in the body.  There is no schedules, steps, name, etc.  The resource versions are different and tonight my plan is to apply the service packs to ensure there is no discrepency in either version.  Also these are all TSQL jobs not DTS packages.  Any ideas?


Upgrade from Win Server 2003R2 to 2008R2 breaks SQL 2005 Reporting Services

  

Upgraded a 64-bit Xeon server (domain controller) from WinSvr2003R2 EE to WinSvr2008R2 EE, no problems with the upgrade process -- AD is functioning as it should.  However, an instance of SQL Server 2005 Reporting Services that was installed on the server now fails with "Error -- The underlying connection was closed:  Could not establish trust relationship for the SSL/TLS secure channel."  

This is an internal site; access is via http on port 80, no SSL.  I assume that the "secure channel" referred to is between the WinSvr2008R2 server and the SQL Server box that houses the database, but I'm not really sure.  In poking around for a solution I was inspired to reinstall the existing SSL cert on the new server, but that didn't help.  There is no cert installed on the database box, but until the upgrade it worked fine.  I've tried a couple of recommended tweaks to the config files for the report server and its web services, no luck there.

I'll be grateful for any ideas.

Jim Shilliday


Jim Shilliday

Jim Shilliday

Migrating SQL Server 2005 databases, including SQL Agent jobs and SQL users

  

Hi,

I should begin to migrate all my data from a SQL Server 2005 (x86) SP3 to another server with SQL 2005 (x64) SP3 installed. About moving the Databases, I think that detach and attach them won't create unexpected problems.

The problems that scare me are:

  1. Migrate the SQL Agent processes. I've created so complex jobs that I'd rather swim across an ocean than rewrite them.
  2. Migrate Users. There are near 70 users with integrated security and each has different mappings to the 40 DBs. Unfortunately there's no domain, so I don't know whether it's possible to copy them without changing their GUIDs.

Does anybody know if my goal is within reach?

Can someone tell me which step to make (and in what order)?

Thank you very much.


Windows authentication SQL 2005 on Windows 2008R2 problem and SP streaming

  

Hello all,

At our customers site we are building a POC (Prove Of Concept) setup and ran into problems. First of all we install SQL 2005 Standard without ServicePack. After this we apply Service pack 3 for SQL. Now we have the problem that the domain admins are not able to connect to the instance in any way. Error is 18456 with state 11. After searching the web I found out that due to UAC, local admins are no longer sysadmins on SQL by default. So I did these two commands:

EXEC sp_grantlogin 'domain\Domain Admins'

EXEC sp_addsrvrolemember 'domain\Domain Admins', 'sysadmin'

Where I of course replaced domain with the appropriate domain name. For Domain Admins this does not seem to work! Also applied it to BUILTIN\Administrators. The local administrator can connect. I then created a new domain group named 'DBadmins'. I applied the exact same commands as stated before to this group, members of this new group can login. When I add the group Domain Admins to the group DBadmins, they do can login. This is of course not a desirable construction. I want all Domain Admins to have access. So I have 2 questions:

1> How can I make sure the Domain Admins group

Issue while migrating reports from SSRS 2005 to SSRS 2008

  

We developed reports for SSRS 2005 using SQL Server Business Intelligence Development Studio (Visual Studio 2005).

 

We migrated these reports for SSRS 2008 using SQL Server Business Intelligence Development Studio (Visual Studio 2008) by opening the Reports project folder in SSRS 2008.

 

After migration when the report is ran without any changes made in the design mode we get the correct output.

 

The issue arises when we try to edit the report in the Design mode. In design mode, it shows only 1 'Tablix Filter' Value and loses the rest of the 'Tablix Filter' values. Specifically, If we try and edit the Tablix properties (In Design mode) all the values in the 'Filters' property disappear.

Windows 2008R2 + MS SQL 2005 Express + "Synchronize" tool ? Where it is ...

  

Hello Everyone,

I just installed in a test setup a replication from SQL Server 2005 to SQL 2005 Express. Everything work fine. However, I like to schedule it to run ever hour. On the express machine, a Windows 2008R2, I cannot find the "Synchronize" tool (Normally in accessory folder). After looking online I ended up copying it from another machine. However, it does not work well.

 

Where is that tool in Windows 2008R2 ? I am doing something wrong ?

 

Thanks


Advice on migrating from SQL Server 2005 Standard SP2 32-bit on Windows Server 2003 Standard SP2 32-

  

We are planning to migrate from SQL Server 2005 Standard SP2 32-bit on Windows Server 2003 Standard SP2 32-bit to SQL Server 2008 R2 Standard 64-bit on Windows Server 2008 R2 Standard SP1 64-bit. Would be grateful for any advice on making such a move.

Thanks,

SQL Servant


How to Encrypt and Decrypt a Password using SQLSERVER 2005?(Video)

  
Encypt and Decrypt a Password using SQLSERVER 2005(Video)

SQL Server 2005 Try and Catch Exception Handling

  
I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

SharePoint document migration challenges when migrating files and folders

  
There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

PollLockedSessionCallback error after migrating to 2.0

  

We have an applicaiton that was converted to the new framework using the wizard in Visual Studio 2008.  When we install the applicaiton in production and change the iis settings to use the 2.0 framework we start to see these errors in the event viewer on the web servers.

We are using SQL Server Session State and have 3 web servers in a load balancer.

 

Object reference not set to an instance of an object.</Message><StackTrace>   at
System.Web.SessionState.SessionStateModule.PollLockedSessionCallback(Object
state

Not sure what is causing this - anyone have an ideas?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend