# Purchase credit Memo Problem **URL:** \ **Category:** Technical Forum\ **Created:** [September 9, 2009, 2:32pm UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893 "2009-09-09T14:32:21Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 9, 2009, 2:32pm UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/1 "2009-09-09T14:32:21Z")
Dear Concern I m having NAV 4.0 SP3 SQL DB,When I posting Purchase Credit Memo then it takes approx. 1Minute per line to post (SQL DB) and all functionalities except this is running fine but I do this process (Same DB) in native DB with same no. of lines then it is running smoothly. Whats the problem? I didnt understand? My DB size is 25 GB and Database used is 22 GB (shows 81%), in Transaction Log File tab(in Alter database window) size of log file is 15450 (MB) and Unrestricted Growth is tick and recovery model is simple and Auto shrink is tick. ---
**Author:** ![marcoferrari](https://avatars.discourse-cdn.com/v4/letter/m/34f0e0/32.png) [@marcoferrari](https://www.dynamicsuser.net/u/marcoferrari)\ **Post date:** [September 9, 2009, 3:38pm UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/2 "2009-09-09T15:38:59Z")
Did you make any customization in the posting process? Activate the Client Monitor and see in which point you experience the problem. There are two points I’ve noted: dimensions and item posting (FIND(’-’) instead of FINDFIRST and FIND(’+’) instead of FINDLAST in the applying function of codeunit 22), but the performance problems must be seen in detail. Marco ---
**Author:** ![marcoferrari](https://avatars.discourse-cdn.com/v4/letter/m/34f0e0/32.png) [@marcoferrari](https://www.dynamicsuser.net/u/marcoferrari)\ **Post date:** [September 9, 2009, 3:41pm UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/3 "2009-09-09T15:41:09Z")
Do not tick Autoshrink! It slows down the performance! Marco ---
**Author:** ![DRB](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@DRB](https://www.dynamicsuser.net/u/DRB)\ **Post date:** [September 9, 2009, 6:13pm UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/4 "2009-09-09T18:13:34Z")
Vikram Size of Log file seems quite high, more than 75 % of total size. And you should increase the database size as 81% usage is bit higher. Use “SQL Profiler” for analysing the code which is taking long time in processing. ---
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 10, 2009, 5:55am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/5 "2009-09-10T05:55:41Z")
Dear concern Can u please tell how can I use “SQL profiler”? I dont know anything about “SQL Profiler”. ---
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 10, 2009, 6:07am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/6 "2009-09-10T06:07:17Z")
Dear Concern I have activated Client Monitor but I havent found any thing in that.If therse is any problem in code then how it is working fine Native DB.Can u please help me.? ---
**Author:** ![DRB](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@DRB](https://www.dynamicsuser.net/u/DRB)\ **Post date:** [September 10, 2009, 6:07am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/7 "2009-09-10T06:07:25Z")
If you are using SQL Server2005, then in SQL Server Management Studio (SSMS) go to Tools\>\> SQL Profiler (or Database Tunning Advisor). One SQL Profiler window opens , go to File\>\> New Trace and do your all activities related to Purchase Credit Memo. SQL Profiler will record the activities done by you and the time taken, from there you can find out what is slowing your system. You may think SQL Profiler as equivalent to Client Monitor of NAV. For more info about SQL Profiler, do a bit googling… ---
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 10, 2009, 6:11am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/8 "2009-09-10T06:11:11Z")
Dear Bansal We r using SQL 2008 how can we do in it?All activities related to Purchase Credit memo will be done in Navision? ---
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 10, 2009, 6:27am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/9 "2009-09-10T06:27:19Z")
Dear Bansal Log files size is incresed by us(Firstly its size is 100 MB then we have incresed it upto 15000MB).Can be there any problem in future? ---
**Author:** ![DRB](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@DRB](https://www.dynamicsuser.net/u/DRB)\ **Post date:** [September 10, 2009, 6:32am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/10 "2009-09-10T06:32:28Z")
> [@](#): > > We r using SQL 2008 how can we do in it?All activities related to Purchase Credit memo will be done in Navision? For SQL Server 2008 also you need to do same. and yes activities related to Purchase Credit memo will be done in Navision. I mean do the activities (Credit memo related) in NAV, Once you are done with credit memo then stop the SQL profiler and you may like to export its data in excel and analyse. ---
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 10, 2009, 6:49am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/11 "2009-09-10T06:49:39Z")
Dear Bansal Log files size is incresed by us(Firstly its size is 100 MB then we have incresed it upto 15000MB).Can be there any problem in future? ---
**Author:** ![DRB](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@DRB](https://www.dynamicsuser.net/u/DRB)\ **Post date:** [September 10, 2009, 6:51am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/12 "2009-09-10T06:51:46Z")
I am not sure about it, so can’t comment on it. ---
**Author:** ![vikram7\_dabas](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vikram7\_dabas](https://www.dynamicsuser.net/u/vikram7_dabas)\ **Post date:** [September 10, 2009, 7:07am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/13 "2009-09-10T07:07:24Z")
Dear Bansal I think that there is problem in any key.It can be? ---
**Author:** ![DRB](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@DRB](https://www.dynamicsuser.net/u/DRB)\ **Post date:** [September 15, 2009, 9:18am UTC](https://www.dynamicsuser.net/t/purchase-credit-memo-problem/22893/14 "2009-09-15T09:18:10Z")
> [@](#): > > I think that there is problem in any key.It can be? Did you use SQL Profiler? Yes, the problem can be because of not using proper key for sorting. Sometimes using “SETCURRENTKEY” and specifying a key for sorting can optimize the process.