SQL 2005 PERFORMANCE

9 Nov 2006 12:52 PM

Jay

Hi,
We are working with SQL 2005 64 Bit server, with 16GB Ram, now our database
size is going 16 Gb, but our server performance is very poor, I setted Min
memory to 1024 MB and Max memory to 14 GB, now my page File usage showing
14.7 Gb, and machine is going slow, some time i saw some transaction is going
Suspended mode,

Can you help me any one ?

mail me Jayamohan***@zenithinfotech.com

Regards

Jay

11 Nov 2006 1:22 AM

Hilary Cotter

You need to run profiler and determine which queries or procs are causing
performance degradation and then optimize them.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quote

"Jay" <J**@discussions.microsoft.com> wrote in message
news:746EB1A8-D89E-4D63-BD28-9B41E48D73FC@microsoft.com...
> Hi,
> We are working with SQL 2005 64 Bit server, with 16GB Ram, now our
> database
> size is going 16 Gb, but our server performance is very poor, I setted Min
> memory to 1024 MB and Max memory to 14 GB, now my page File usage showing
> 14.7 Gb, and machine is going slow, some time i saw some transaction is
> going
> Suspended mode,
>
> Can you help me any one ?
>
> mail me Jayamohan***@zenithinfotech.com
>
> Regards
>
> Jay

11 Nov 2006 11:33 PM

Greg Linwood

Hi Jay

Was this database upgraded from SQL 2000 recently? If so, did you update
your index statistics or rebuild your indexes? It's important to do one or
the other with an upgraded database, otherwise performance dives under SQL
2005 when a db has been upgraded from 2000.

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood

Show quote

"Jay" <J**@discussions.microsoft.com> wrote in message
news:746EB1A8-D89E-4D63-BD28-9B41E48D73FC@microsoft.com...
> Hi,
> We are working with SQL 2005 64 Bit server, with 16GB Ram, now our
> database
> size is going 16 Gb, but our server performance is very poor, I setted Min
> memory to 1024 MB and Max memory to 14 GB, now my page File usage showing
> 14.7 Gb, and machine is going slow, some time i saw some transaction is
> going
> Suspended mode,
>
> Can you help me any one ?
>
> mail me Jayamohan***@zenithinfotech.com
>
> Regards
>
> Jay