tag:blogger.com,1999:blog-5430866.post4763976170632347173..comments2024-01-02T08:54:14.406-05:00Comments on Peter Bromberg's UnBlog: SQL Server 2008 64-Bit vs 32-Bit Performancepeterbromberghttp://www.blogger.com/profile/18173639411723574123noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5430866.post-75357144705328463992012-07-15T05:38:17.480-05:002012-07-15T05:38:17.480-05:00Hi,
After up gradation to 64-bit server, some of ...Hi,<br /><br />After up gradation to 64-bit server, some of my crystal reports began to run slow. They run fast some times and some time very slow. Can you pl help??Ginni Kakkarhttps://www.blogger.com/profile/03425749971407043341noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-22593709291894444232012-07-15T05:36:48.427-05:002012-07-15T05:36:48.427-05:00I had a bit problem, after up gradation to 64-bit ...I had a bit problem, after up gradation to 64-bit server, some of my crystal reports began to run slow. I am unable to find the fix. Can u pl help??Ginni Kakkarhttps://www.blogger.com/profile/03425749971407043341noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-12637445099410154062011-10-03T09:44:12.108-05:002011-10-03T09:44:12.108-05:00You are a life saver.
Java Interview Questions for...You are a life saver.<br /><a href="http://extreme-java.com/java-interview-database-sql-jdbc/" rel="nofollow">Java Interview Questions for Database</a>Sandeephttps://www.blogger.com/profile/14459583259453333684noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-18122844850250134692011-04-05T14:00:38.930-05:002011-04-05T14:00:38.930-05:00Thank you for this. You saved me a lot of time.Thank you for this. You saved me a lot of time.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5430866.post-68408762437032247392010-02-17T20:10:05.967-05:002010-02-17T20:10:05.967-05:00Peter,
Try this page "Performance Tuning and...Peter,<br /><br />Try this page "Performance Tuning and Optimization of Full-Text Indexes" ( http://msdn.microsoft.com/en-us/library/ms142560.aspx )<br /><br />There are best practices for memory, cpu, etc., in particular covering "Troubleshooting Full Population Performance Issues" on x86 (with and without AWE) and x64 and IA64. The SQL Server 2008 Storage Engine can be limited on memory as Dan had mentioned, but fdhost.exe also needs to be managed.<br /><br />And 6 million rows is big? That's 4 hours of data in one of my apps :)<br /><br />Hope that link helps.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5430866.post-6528074791205178242010-02-02T17:35:59.005-05:002010-02-02T17:35:59.005-05:00@Dan, yes i did set max SQL Server memory to only ...@Dan, yes i did set max SQL Server memory to only 2GB. It had no effect. As mentioned, this problem with the x64 version only occured when I added a FullText Catalog to a very large (6 million rows) table, on one varchar column.peterbromberghttps://www.blogger.com/profile/18173639411723574123noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-1018530295311634842010-02-02T16:39:59.209-05:002010-02-02T16:39:59.209-05:0064-bit version will try to leech out as much RAM a...64-bit version will try to leech out as much RAM as it can from the OS. Have you tried to reduce the Max memory to < 4GB? By default, the installation sets it to as much memory as you have. <br /><br />My experiences:<br />http://www.shinylight.com/2009/09/18/upgrading-from-sql-server-2000-to-2008/<br /><br />http://www.shinylight.com/2010/01/28/sql-server-2008-installation-errors/Unknownhttps://www.blogger.com/profile/00049049016960368608noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-15216040077196862692010-02-01T13:22:26.542-05:002010-02-01T13:22:26.542-05:00@Mark, the post focuses around issues with FullTex...@Mark, the post focuses around issues with FullText and the building of catalogs for same. I never ran into the mentioned issues before beginning to index a large table with a fulltext index.<br />Thanks for the comment.peterbromberghttps://www.blogger.com/profile/18173639411723574123noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-40919258352704250072010-02-01T11:59:16.703-05:002010-02-01T11:59:16.703-05:00Interesting observation Peter. I have SQL Server ...Interesting observation Peter. I have SQL Server x64 working here with some tables/queries dealing with 50+ million rows and it is working fine. Mind you, those boxes are very beefy with multi processors, and 5 times as much RAM as you mentioned.<br /><br />I have the developer edition on my box and it is also running fine for queries of 1 million rows, BUT, I am running 8 Gig ram.<br /><br />I did find issues with running certain SSIS packages, but when I turned off 64 bit in the Project settings, they worked fine.Mark Kadlechttps://www.blogger.com/profile/01023381592330342023noreply@blogger.com