Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Large Table, Heavy Queries
Message
 
À
14/04/2012 07:42:58
Aman Bains
Jaguar Computers
Jalandhar, Inde
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01541513
Message ID:
01541519
Vues:
39
>My Database has 3 Large tables-
>-VoucherHeader - Common for all vouchers
>-VoucherDetailTypeA - Type A voucher detail
>-VoucherDetailTypeB - Type B voucher detail
>All entries go to Header, but Detail goes to TypeA or TypeB.
>All Financial Years data is in these 3 tables.
>
>Inserts are not causing any problem.
>
>***The Ledger Report is causing problems. CPU 100%, RAM 100%
>
>At Month End or Year End more than 100 users constantly open the ledger repeatedly for different accounts. All users view Ledger for same Financial Year and for a small date range.
>Query - fetches large amount of data involves self join to show all other opposite accounts except the selected account for each voucher.
>Hardware- Sufficient RAM 16 GB, Sufficient CPU 4 cores on a virtual Server
>Indexing - Sufficient Indexes to speed up are there.
>
>****Please suggest solution. Is partitioning a solution? but we have Standard edition & can't buy Enterprise edition. But since the report runs for same period so to me it seems partitioning might not help.

What is execution plan?

MartinaJ
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform