| Author |
Topic |
|
loknathmahato
Starting Member
27 Posts |
 Posted - 2012-09-12 : 19:10:03
|
| Hi Friends,I have a Database Server which configuration is as follows.RAM - 16 GBSystem Type - 64 Bit Processor - Intel(R) Xeon(R) CPU E5506 @2.13 GHZ (2 processor)OS - Windows Server 2008 R2 SP1 Enterprise Edition[64bit]Database - SQL Server 2008 R2 Enterprise Edition[64bit]I have assigned 12 GB of RAM for Database and rest for OS but during the production hour when i move/copy 3 to 5 GB file from one drive to another drive or restore some old database or take any backup OS takes all the memory and for the moment when this activity happens database get locked and we can not fire any sort of query or the task related to database.Please help.Thanks |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-12 : 19:13:01
|
| How are you determining that the OS is taking the memory?-Chad |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-13 : 01:48:21
|
| Depending on how you copy a file , it can slow the system down. There's a tool I use called ESEUTIL - which uses unbuffered IO - the tool is part of the Excchange software.With the Backups , it is a very IO intensive activity , are you backing up to a non data or log file drive?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
loknathmahato
Starting Member
27 Posts |
Posted - 2012-09-13 : 11:22:42
|
[quote]Originally posted by chadmat
How are you determining that the OS is taking the memory?-ChadI have monitored it in Windows Task Manager.In normal production hour Memory Utilisation show between 11 Gb to 12 GB but when i perform these sort of activity the memory utilization show upto 16 GB.Thanks |
|
|
|
loknathmahato
Starting Member
27 Posts |
Posted - 2012-09-13 : 11:26:10
|
quote:
Originally posted by jackv
Depending on how you copy a file , it can slow the system down. There's a tool I use called ESEUTIL - which uses unbuffered IO - the tool is part of the Excchange software.With the Backups , it is a very IO intensive activity , are you backing up to a non data or log file drive?Jack Vamvas--------------------http://www.sqlserver-dba.com
Yes. But why this is happening during the database restoring time as well.Thanks |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-13 : 12:32:38
|
| Task Mgr doesn't tell us that the OS is using the memory. What process is consuming the memory? Use perfmon and monitor all processes and see which one consumes the memory.What does I/O latency look like during this period? Both backup and file copy are I/O intensive. Are you backing up to a SQL Data or Log drive?-Chad |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-13 : 16:38:56
|
quote:
Yes. But why this is happening during the database restoring time as well.
The Restore could be experiencing the issue due to many different reasons? 1) Are you restoring to the relevant drives2) If there is a CREATE DATABASE process involved , do you have Instant file initialization rights assigned to the service account?3) Could you post the drives and layout of the data and log files?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-13 : 16:59:58
|
| You could be suffering from excessive file cache bloat:http://blogs.msdn.com/b/ntdebugging/archive/2009/02/06/microsoft-windows-dynamic-cache-service.aspxhttp://www.brentozar.com/archive/2012/06/sql-server-poor-performance-checklist/ (3rd item)If you are copying files via drag and drop, do not do that from the machine running SQL Server. Connect to the other machine, or try Robocopy. I don't believe this affects a restore operation unless you've copied the backup file to the server. |
|
|
|
|
High Memory Utilisation