Scenario: SQL Database Vs Native Database
1. Currently I am using SQL database for one of my client and not able to run adjust cost on daily basis in 6 Hrs.
Task already done for SQL performance improvement
Quad Core Processor(64 Bit)
52 GB RAM
SQL Database is already divided into 10 Disk with RAID proper configurations.
Maintenance Plan run on regular basis including index maintenance
2. For month closing I need to take backup of system and restore in native database.
I don't don't want to do this activity again.
My requirement is make SQL performance up to Native database performance.
Friends pls suggest me the best feasible way out to improve SQL performance considering above scenarios.
GL - 10020561
3 Months Transactions
KRISHNA PAL SINGHMS-Dynamics -NAVISION