SQL performance - MDAC version?

Miklos_Hollender

Somebody mentioned in a topic that unreasonable SQL server performance issues (with 4.0, without SP1) can be caused by old MDAC version. I have exactly that, completely unreasonable performance issues: Navision stops for half a minute or even freezes completely when doing stuff without much database usage, like keying in Quantity to an order, or choosing an Item. I generally checked the ideas in the SQL manual and have no foolish developments, so I guess it might be my problem.

I have wrote a small tool to check it:

//Name	DataType	Subtype	Length
MDAC	Automation	'Microsoft Data Access Components Installed Version'.Version	


CREATE(MDAC);
MESSAGE('MDAC version: ' + FORMAT(MDAC.String));

I have sent it to the customer and is very interested in the result. I hope it will be the solution, because I have 2.82 on the termserver and could never reproduce the performance issues there. However, I would like to ask that do I have any chance of installing MDAC2.8 SP1 ( I think it is the latest) to an Win2K box? And can anybody tell any reason why can't I install it on my XPSP2, why does it say my OS is not compatible? And how comes I have 2.82 installed on the termserver when 2.8SP1 supposed to be the latest one?...

ara3n

I have version "2.81.1117.0" installed. I received the same error when I tried to install sp1. I recently installed sql 2005 express version and ever since I haven't been able to connect to sql 2000 server from my computer.

ara3n

2.8 Sp1 can be installed on following os

Minimum supported configuration
• Microsoft Windows 98 with the Y2K Update 2 and Internet Explorer 5.01
• Microsoft Windows 98 Second Edition and Internet Explorer 5.01
• Microsoft Windows Millennium Edition and Internet Explorer 5.01
• Microsoft Windows NT 4 Service Pack 5 (SP5) or a later version, and Internet Explorer 5.01
• Microsoft Windows 2000

Miklos_Hollender

Thanx. It turns out we are having the same stuff on the termserver too, where MDAC is 2.82. This is just amazing. I mean it is clearly not a performance problem, because if you have a performance problem, it should appear every time, and usually at heavy postings or FlowField calculations. While at my client it just appear *sometimes* and at trivial tasks such as keying in a Quantity to an Order, and there is no uneffiecent code there, I checked.

I have only one idea left - LS Scheduler is picking up transactions from stores every hour, and maybe it's that what causes this. I will have users register the exact time of such problems and check it with the scheduler log.

If it's not the cause of problem, then I am completely clueless, I will have to call for external help...