SQL Server Performance Forum – Threads Archive

sql server very slow

dear all,
i have the same problem with Cache hit ratio it show 60-70 % which normal is 85-90 % so it very slow when use application and it use memory only 1.7 gb ,i try to reindex and update statistics but it’s still the same
i have detail about my server for every and configuration
– windows 2003 advance server
– sql server 2000 sp3 standard edition
– ram 4 GB
– cpu intel xeon 2.8 Ghz Rgds, My sql configuration
name minimum maximum config_value run_value
———————————– ———– ———– ———— ———–
affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 32 32
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2625 2625
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 0 0
nested triggers 0 1 1 1
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0
Performance captureObject: MSSQL$THCUSTOMS:Buffer Manager
AWE lookup maps/sec 0.000
AWE stolen maps/sec 0.000
AWE unmap pages/sec 0.000
AWE write maps/sec 0.000
Lazy writes/sec 0.000
Page reads/sec 0.000
Page writes/sec 0.000
Total pages 208208.000 Object: MSSQL$THCUSTOMS:Cache Manager _Total
Cache Hit Ratio 62.830
Cache Use Counts/sec 18.997 Object: MSSQL$THCUSTOMS:General Statistics
Logins/sec 0.000
Logouts/sec 0.000
User Connections 62.000 Object: MSSQL$THCUSTOMS:Memory Manager
Connection Memory (KB) 2464.000
Granted Workspace Memory (KB) 5040.000
Maximum Workspace Memory (KB) 1205832.000
Memory Grants Pending 0.000
SQL Cache Memory (KB) 1320.000
Total Server Memory (KB) 1678856.000 Object: Network Interface HP NC7760 Gigabit Server Adapter
Bytes Total/sec 17321.038
Current Bandwidth 100000000.000 Object: PhysicalDisk _Total
% Disk Time 10.780
Current Disk Queue Length 0.000
Disk Read Bytes/sec 32775.642
Disk Reads/sec 4.001
Disk Transfers/sec 13.003 Object: Processor _Total
% Processor Time 100.000
% User Time 87.500

Are there any other applications running on the server, which might be competing with sql for memory ?

yes , many application but in the part it’s not have problem why 2-3 month ago it’ happen ?
i don’t understand . could any body advice me to resolve this matter ? Rgds

Run Profiler and see if anything goes wrong Madhivanan Failing to plan is Planning to fail

KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;224587 and linkhttp://www.sql-server-performance.com/articles_performance.asp for further information to troubleshoot. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Do you have maintenance plan like reindex and Updates statistics? Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Yes ,i have maintenace setting schedule everyday but not help ,it still the same

]]>