mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 10:36 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: SQL 2000 & VMWare
PostPosted: Tue Feb 09, 2010 11:26 pm 
Offline

Joined: Mon Oct 04, 2004 7:42 pm
Posts: 101
Location: LA
Country: United States (us)
Hi,

We have the following:
* SQL server 2000
* Nav 2.6
* 32gb database on IBM SSDs

We recently moved out SQL server over to a VMWare machine and upgraded to SSDs for our 32gb database. We've been getting performance issue where the database slows down and occassionally the navision client will disconnect.

Performance monitoring shows the VMWare box is underutilitized by all services, we've even expanded networking with no success.

Has anybody had similiar experiences moving to VMWare. I'm thinking of moving back to metal.

Thanks,
Mega


Top
 Profile  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 12:50 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
Can you do an EXE upgrade?

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 1:06 am 
Offline

Joined: Wed Oct 15, 2008 12:15 pm
Posts: 415
David Singleton wrote:
Can you do an EXE upgrade?


and lose all MS support?


Top
 Profile E-mail  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 1:27 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
generic wrote:
David Singleton wrote:
Can you do an EXE upgrade?


and lose all MS support?


I think you will find that neither 2.60 nor SQL 2000 are supported anyway. :mrgreen:

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 1:31 am 
Offline

Joined: Mon Oct 04, 2004 7:42 pm
Posts: 101
Location: LA
Country: United States (us)
David Singleton wrote:
generic wrote:
David Singleton wrote:
Can you do an EXE upgrade?


and lose all MS support?


I think you will find that neither 2.60 nor SQL 2000 are supported anyway. :mrgreen:


There's no problem upgrading to 5.0, I'm doing an upgrade to 5.0 right now and even the 5.0 client disconnects.


Top
 Profile  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 2:02 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
megawavez wrote:

There's no problem upgrading to 5.0, I'm doing an upgrade to 5.0 right now and even the 5.0 client disconnects.


Sorry I was thinking more of the performance side than the disconnects. A small database like this should not really have any major performance issues that can't be fixed with a bit of configuration and tuning.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 2:07 am 
Offline

Joined: Mon Oct 04, 2004 7:42 pm
Posts: 101
Location: LA
Country: United States (us)
Performance has gone down a bit, but the biggest irritation is the erratic disconnects. Seems to be some strange interaction between SQL 2000 & WMWare.

Out network guy is going to upgrade to the newest ESX this weekend, but I have a feeling the problem will still be there...


Top
 Profile  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 12:10 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 3849
Location: Olst
Country: Netherlands (nl)
NAV 5.0 is the last working version for SQL2000.

I would also look for the solution in SQL, not NAV.

What happens if you connect management studio or profiler? Does it loose connection as wel?

SQL2008 is the only SQL Server version which is supported for VMWare but I have tons of happy SQL2005 customers as well.

SQL2000 is becomming quite old quite fast. I would suggest getting some quotes on upgrades.

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Developer
Author of the book : Microsoft Dynamics NAV 2009 Application Design

MY BLOG : http://www.brummelds.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 12:12 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 3849
Location: Olst
Country: Netherlands (nl)
Another question from my side, how is the temperature doing of the SSD drives? I've always thought that they were getting very hot on heavy random I/O tasks. Can you see that information somewhere?

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Developer
Author of the book : Microsoft Dynamics NAV 2009 Application Design

MY BLOG : http://www.brummelds.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 2:35 pm 
Offline

Joined: Wed Oct 15, 2008 12:15 pm
Posts: 415
you could test sql 2005 with express version on a smaller db and see if you are still loosing connection.


Top
 Profile E-mail  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 3:51 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
Mark Brummel wrote:
NAV 5.0 is the last working version for SQL2000.

I would also look for the solution in SQL, not NAV.

What happens if you connect management studio or profiler? Does it loose connection as wel?

SQL2008 is the only SQL Server version which is supported for VMWare but I have tons of happy SQL2005 customers as well.

SQL2000 is becomming quite old quite fast. I would suggest getting some quotes on upgrades.



Sorry I might not have been clear, but when I said upgrade, I was referring to both Navision and SQL.

We have a client now testing Nav 4.00sp3 exe and SQL 2008 with aver 500gig on VMWare and not seen any problems, in about 3 months of testing.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 10, 2010 11:48 pm 
Offline

Joined: Mon Oct 04, 2004 7:42 pm
Posts: 101
Location: LA
Country: United States (us)
Management studio also disconnect periodically, so definitely a problem with the SQL Server. I've got a feeling upgrading to SQL 2005 wouldn't fix the problem - I think it's somewhere else.


Top
 Profile  
 
 Post subject: Re: SQL 2000 & VMWare
PostPosted: Wed Feb 17, 2010 8:02 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12265
Location: Brno
Country: Czech Republic (cz)
May be somewhere on physical network...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: