Hi all,
My client is reporting that my .net application is creating 60% burden
on database,how can i reduce this burden please help me out.
schneider - 28 Mar 2007 18:20 GMT
Close any unused connections.
Make sure you create as few connections as possible.
Call Dispose on DB objects when nolonger needed.
Schneider
> Hi all,
> My client is reporting that my .net application is creating 60% burden
> on database,how can i reduce this burden please help me out.
PS - 03 Apr 2007 17:51 GMT
> Hi all,
> My client is reporting that my .net application is creating 60% burden
> on database,how can i reduce this burden please help me out.
You need to determine what is causing the workload. Is it the application or
is it the database? By the application I mean that the application is
accessing the database constantly or requesting too much information like
extremely large tables. By the database I mean that the database design
(e.g. the indexing) is inefficient making it work hard and do table scans
etc. It could also be a combination of these 2. You can start by profiling
the database activity and then by examining that you can see the frequency
and the amount of time that the database is being used.
PS