-
Transaction LOG Backup getting locked?
Hello, I have been monitoring blocks in SQL server to try to understand what queries are creation blocks. I see that the Transaction Log Backups are getting blocked. I have a maintenance plan that creates Transaction Log Backups every 30 minutes. Does those backups can create locks or get locked by another user. In my…
-
Alter Database Settings Issue
hi, Our Client systems are reported to be slow these days. i think its due to very low free space. Currently database Used :88-90%. We are working on nav 5.0 with sql server 2005, DB settings are : Primary datafile is 120MB, File Growth -1280% & unrestricted growth TRUE Secondary datafile 1699MB, File Growth -10240KB &…
-
Very slow NAV 5.0 with SQL2005
Hello, I'am working with Dynamics Nav 5.0 with SQL Server 2005,it's going very slow with a lot of Lock error!!! :-k For more information about our System: Hard: Intel Xeon Quad 2,5GH 6GB RAM Network 100MB of speed 3 logic partition of HD 400GB Soft: Widows server 2003 R2 Our DB has: Used Space:94,2GB Reserved Space:104,2GB…
-
SP1 List form performance
Since upgrading from 4.0 SP1 to 2009 SP1, my customer list form is performing HORRIBLY. We are a retail company so customer lookup performance is critical. The lookup form is sorted on the Searchname key. We use SQL2005, the classic client. Not sure if this is part of the problem but we use a SQL Collation- Binary sort…
-
Speedup performance of database
Hi, We are a Navision customer for 4 years and started with the classic version and are now using the 5.0 SQL version. We do most of our development ourselves (just changing/creating reports). Our database is growing by the minute with on average 400/500 orders a day (5/20 lines). Are there consultants we can help with…
-
Filtering On a Flowfield
Hi all, I have a requirement where a customer has an overview screen for all Sales Order Lines. There is a flowfield that has been added to the Blanket Order Subform of "Qty. on Sales Order", which they wish to see as a column on this overview. However, and this is where it starts to fall apart, it that it is also required…
-
SQL Server Optimization for nav2009
Just found this, thanks to RSS if you didn't already know about it https://mbs.microsoft.com/partnersource/communities/training/trainingmaterials/student/course80156.htm However, i haven't read it yet...
-
Extremely slow ISEMPTY, even with a good index???
SQL2008 (build 10.0.1600) with NAV5SP1-Upd1 (build 27191) I have a lot of ISEMPTYs that shows up in the Profiler as very expensive which I find rather strange. Example: SELECT TOP 1 NULL FROM "MyDatabase"."dbo"."MyCompany$Item Ledger Entry" WITH (READUNCOMMITTED) WHERE (("Prod_ Order No_"=@P1)) AND (("Prod_ Order Line…
-
Restore Very Slow - SQL 2008 - NAV 4.0SP2
I am preparing for a migration from Nav 4.0sp2 to NAV 2009. I have backed up our live database (SQL 2005) and it has created 29 fbk files total 56.6gb. Our database has 4 companies. The backup took 3 hours. I can live with that. Destination server is a DELL R7100 - 64bit dual quad core server with 40gb ram. Server 2008…
-
new trace flag 4119 for sql 2008
Hello When I do sql 2005 installation, in addition to T4616 trace flag, I set trace flag T4119 This is mentioned in the link below. http://blogs.msdn.com/microsoft_dynamic ... 5-sp2.aspx Is this needed in sql 2008? tnx
-
Best Pratices
Hi guys! Can you send me a compilation of topics that you think that are very important to anaylise SQL Performance. I´m newbie in this area an i want to read more about this subject. For example on the instalation: Should i limit the MEmory used by the SQL Server? When i create/Attach a database what is the best pratice…
-
Bad performance / unable to restore
Hi – I’m not sure if this is the correct forum, but I have a serious problem restoring a 5.0 NAV database on SQL. It is just a small db, but it contains 510 companies. When I do the restore on a native server it takes app. 2 hours. Now I have tried restoring this several times on SQL, but after 30 -35 hours the process…
-
cursorfetch problem or query plans need hinting?
First post so please bear with me ;) We used to have a lot of Navision performance problems but that changed when we a. upgraded our san array's disk speeds from 10K to 15K. b. stopped running perfmon and profiler directly on the SQL 2K5. However the problems are still around, just less frequently. I've begun to think it's…
-
Disk Storage
We are planning to upgrade to Dynamics Nav 2009 and we are spec’ing out a new SQL Server and we are exploring the options in regards to disk storage. Along with the traditional SAN we were looking at the IBM XIV storage system (http://www-03.ibm.com/systems/storage/disk/xiv/http://www-03.ibm.com/systems/storage/disk/xiv/).…
-
ask about database engine tuning advisor sql server2005
Hi, I use database engine tuning advisor for my query and the tool recommend me to apply some indexes and statistic. the tools said if I apply the thing it will improvent my performance for 99%. my questions is, if i apply database engine tuning adviosr.from navision side,is there any impact if I apply their…
-
dbcc FREEPROCCHACE
I'm contemplating on clearing the Query Execution Plan cache. Or db was now gone from a test to go live condition, and I want to be sure to be sure that the plans been used are up to date and reflect real life data. I have some basic knowledge of the qep's that could be generated, and I am looking for reassurace that if I…
-
Disabling SIFTLevelsToMaintain
Hi, Our Client is running on 3.7. We face performance issues quite often now. I went tru most of the posts here and learnt that If I have keys defined as below: 1.Key: G/L Account No.,Posting Date. SIF : Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount.…
-
Navision is Running Very Slow
Hi, I'm running Navision 3.70. Over the past few months, it has been running very, very slow. I'm getting numerous locks in SQL server more and more often - doesn't seem to release as quickly? A maximum of 81 sessions are able to log on to Navision to access the data. My database information is as follows: Database Used…
-
Error when trying to create a backup
Here is a situation: i am trying to backup a SQL based NAV database. But getting this error There are errors in the text conversion (text no. 1965-0 does not exist in the .stx file). Internal error: 47-1
-
Read/Write Cache on RAID Controller
We are trying to figure out the best setting for our Read/Write Cache. It is currently set to 50/50. Anyone have thoughts as to the best setting when it comes to NAV on SQL? SOme background info: We are running on SQL 2008, NAV Exectuables NAV 2009. Our database is 120 gb, we have 10 NAS's running 24 hours a day and will…
-
Slow SQL after updating to SP3
Hello, we have a problem at hand - after updating from 4.0 SP2 to 4.0 SP3 and disabling index hinting the whole database turned to crawl. So much, in fact, that it takes 10 minutes to open for example detailed customer ledger entries. Monitoring shows heavy tempdb usage. Otherwise, neither other disks nor CPU are…
-
NAVISION 4.0 SP3 WITH SQL SERVER 2005 SP3
HELLO. WE HAVE UPGRADED SQL SERVER 2005 SP2 WITH HOTFIX 11 TO SQL SERVER 2005 SP3 AND THE PERFORMANCE OF THE SQL HAVE FALLEN IN A WAY THAT IS ALARMING (WITH ONE USER, IT TAKES MORE THAN 1 MINUTE REGISTERING A TRANSFER BETWEEN WAREHOUSES). ANY SUGGESTIONS???????
-
Poor performance due to wrong setup on sql
Hi! I'm lookin into the solution for one of our customer. I am not very familiar with setting up and configurate NAV on sql server, but this time I have got to find out why the customers database is running very slow. They complain about bad performance, sometimes the whole system hangs for about 10 seconds and all…
-
Multiple DB accesses overhead
Hello everyone, I am trying to optimize an existing system which is currently using LINQ. I have a section where LINQ makes 4-7 database queries for different sections of data based on a primary key. Each query is obviously very fast (1-10ms on SQL Server Profiler), but I am concerned that there may be overhead in making…
-
Verify Backup Checkbox
We are mving to SQL 2008 Thursday evening. I have done much testing an I now realize something very weird when setting up the backup jobs. First off a regular backup takes about 25 minutes. As soon as I click the "Verify Backup When Finished" checkbox it causes the backup to take 2 hours! You can actually run the "Verify…
-
tempdb
hello. i was reading this 10 best practice and saw this. http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx so basically one data file each having it's own file group per cpu? is there a configuration on cpu will utilize each data file?
-
Performance/speed degradation
Hi, We have a client who is experiencing a gradual decrease in speed on a particular process. There has been no recent changes to the code. They are using Navision 3.70B with SQL Server. Has anyone encountered a similar problem? A few things they have done is rebuilt the indexes (using SQL maintenance). Last year the…
-
How to improve posting process time
How can I improve posting process time on NAV 5.0 SP1 SQL database? :-k
-
Multiple SQL Data Files and NAV
We have a RAID 10 Array that is almost full. We would like to add an additional RAID 10 array to the drive enclosure and add another secondary data file to store on this array. We haven't split the NAV database into multiple data files before and are not sure if this is recommended or supported. Has anyone done this before?
-
Event-ID 17401 on SQL Express
We have a customer who uses Entrepreneur with a SQL Express database server. The customer complains that the response time is, at times, very slow. I checked the eventviewer of the server and it contained the ID 17401 "Server resumed execution after being idle <number> seconds: user activity awakened the server. This is an…