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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Max Memory w/ SQL 2005 and SQL 2008 on same box

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
We found we have a small need for a SQL 2005 instance and so it was placed on the same server as SQL 2008.  Any suggestions on how max memory settings should be configured with both versions on the same server?Lossless Audio Addict

View Complete Post

More Related Resource Links

How to find out how memory is allocated in SQL Server 2005/2008?


I want to find out how to get memory information from SQL Server using DMVs that will equal to or be very close to the memory shown in Mem Usage column of Windows Task Manager for sqlservr.exe.   I have tried to sum single_pages_kb, multi_pages_kb, and virtual_memory_committed_kb from sys.dm_os_memory_clerks but the combined total is still less than the Mem Usage from Windows Task Manager.  

Visual Studio 2008 Memory problems


My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.

Converting Crystal Report 2005 to 2008 - Please Tell Me I'm Stupid :)


Hello peeps,

  I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues.  The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues.  The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file.  I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.

  Is this normal?  Is there an easy conversion method that I'm simply overlooking?  Am I screwed?  Who invented liquid soap, and why?

Answers to any of these questions would be greatly appreciated...

Convert 2005 RDLC to 2008 using VS2010


Hi and thanks.


I'm getting an error on serveral reports that I built  in VWD2005 (express) using the reportviewer control.  Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok.  When I build the site, I get this error (and of course also when the report is ran):


Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1 


Here is my web.config concerning the RDLC assemblies, etc.

			<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
		<compilation debug="true">
				<add assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="Microsof

VS 2005 to 2008


Hi folks

Am in the process learning C#, My instructor uses Visual C# 2005 Express and on my side I have Visual Studio 2008 Pro.

Do you think it will affect me in my Coding practice due to the different IDE Versions? Wha do I have to heed when coding?



SQL server 2005 2008


i cant install sql server 2005 nor 2008 on my windows 7 os

i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,

can you plz help me??


SQLServer 2008 Tools and SQL 2005 Cluster

I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2.  I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set.  I have been unable to attach to this cluster since its creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running. I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get.  I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but the client never responds after the initial UDP response. When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster.  So my question is - Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set?  I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.   Error when attempting to connect: A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is con

sql 2005 sp2 memory error FAIL_VIRTUAL_RESERVE

We're running SQL Server 2005 SP (9.00.4035.00) 32 bit on Windows Server 2008 SP2 Enterprise.   The server has 8gb of RAM and is only used for SQL Server.  Since Windows 2008 SP2 was installed on 8/23/2009, once every week or so the server has become unresponsive.  Early in in the course of the problem I notice the following error in the SQL Server error log:  Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576 That's followed by the output of DBCC MEMORYSTATUS, which I'll include at the end of this post. After that, things work normally for several hours, except for some occurences of Downgrading backup log buffers from 1024K to 64K That appear in the SQL Server error log when our transaction log backups occur.  Some time after that, we begin to receive Event ID: 701 There is insufficient system memory to run this query. In the event logs of our server. At that point, the server becomes unresponsive.  Restarting the SQL Server Service resolves the issue. Is anyone else experiencing this? It's only been happening 1 time per week (not consistently the same time) and has only occurred since Windows Server 2008 SP2 was installed.  I don't know if that's related, but it's the only real change to that server.  Workload has been consistent on that server for months. Can someone please help? Thanks. Here's the DBCC output. Memory Manager     VM Reserved =

migration and upgarde from 2005 to 2008

we need to migrate the data from Houston to Seattle. plus, we need to upgrade 2005 server to 2008 at the same time, with the minimal downtime. The plan is to build the brand new 2008 server in Seattle, restore all databases (500 on the same server!) from full backup. when ready, shutdown applications in Houston, run diff backup and restore Seattle from diff. My question is about initial restore of master database in Seattle. is it a problem to restore 2005 master db on 2008 server?JulieShop

WmiPrvSE.exe causes a huge memory leak in SQL server 2008 R2, why?

My OS is windows server 2008 r2 data center 64 bit and my SQL server is server 2008 R2. The problem is when I open sql server, the WmiPrvSE.exe process consumes 20 - 60kbs every second. Several hours later, it eats up at least 200mbs memorry and this process seems like it will never stop. Can any experts give me some ideas to fit this mess? PS: My mainboard is Asus striker II formular, cpu is intel quad-core. Also, all my software are updated to latest version.

SQL 2005 db, edited in 2008

Hi all,I backupped a database from SQL Server 2005, edited it locally in my SQL Server 2008 Express (with Tools) and then tried to restore it back to the 2005 server again. This didn't work and gave several errors in the 2005 server, depending on the way I tried to restore it - or re-attach it. The errors are: Database cannot be opened becaus it is version 655. This server supports version 611 and earlier. The media family on device 'C:\Temp\backup2008\backup2008.bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)In other words: the database/backup is just fine, but SQL 2005 just doesn't swallow it. I have already confirmed that the compatability level on SQL 2008 Express (localhost) is set to '90', by using select * from sys.databases, which should mean that it is backwards compatible. I have also tried both restoring through the Management Studio and by script, as well as (re-)attaching the files. I just can't get it to work...Somewhere, it sounds logic. On another level I fail to see the point of the compatability level in the options if this is not possible. Any advice? Or do I just have to forget about SQL 2008 on my working machine and rollback to SQL 2005?

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

AdomdDataAdapter.Fill returns memory error when querying an SSAS Cube(2008)

For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object. "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."   Snippet of Code: DataSet ds1 = new DataSet(); AdomdCommand acmd1 = cn1.CreateCommand(); acmd1.CommandText = "SELECT ..."; AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1); ad1.Fill(ds1);   Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.   When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?  

SSAS 2008 - Memory Error

During our unit and load testing of the SSAS database using VSTST 2010 Ultimate; we are getting a memory error with some of our MDX queries (below).  Futher analysis showed: The adomdDataAdapter "Fill" command is our error point The error is occuring when the result data set has getter than 16,384 Columns; actual returned column count is 41,339 columns - business requirement does not let us change this query at this time. The MDX query works fine in MS Excel 2007 The MDX Query works fine in MS SQL Studio 2008 How can we resolve the unit test data set with such a large column count? Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed. In reference to thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4220adbb-438c-42e7-9612-56aebf8df435/ Thank you, Craig  

Replication between SQL Server 2005 and SQL Server 2008

Hi,    We were using SQL Server Transactional Replication between two SQL Server 2005 servers. Now we are going to upgrade the Publisher server to SQL Server 2008, Distributor Server remains as SQL Server 2005.     Can anyone let me know what is the challenges we need to face when configuring Replication between SQL Server 2005 and SQL Server 2008. Replication Method - Transactional Replication Distributor/Subscriber - SQL Server 2005 Publisher     -  SQL Server 208 Regards, Fazlu.

DTS_I_SUCCEEDEDHASHINGCACHE : Datacode 1075876066 : new Informationline in SQL 2008 vs. 2005

Hello guys, I've a simple question where i didn't found an answer yet: The processing time is in Seconds - but CPU Usage seconds or wait time seconds until the caching is finished ? Output of onlinebooks: The %1 processed %2!u! rows in the cache. The processing time was %3 seconds. The cache used %4!I64u! bytes of memory.   hope that anybody has the much sought-after answer...   thanks & greets from Austria | TiROL Alex
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