Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Reducir consumo de ram de sql2008  (Visto 953 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline punkjaja Posteado: March 22, 2019, 07:11:39 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 282
  • Gracias recibida: 300
  • cl
Buenas eh escuchado a varias personas que pueden reducir el consumo de la sql 2008 alguien sabra la forma de hacerlo? Tengo un vps de 3 de ram


Offline joacoRu #1 Posteado: March 22, 2019, 07:40:44 PM

  • 0 puntos por ventas
  • *
  • Rank: Principiante
  • Posts: 28
  • Gracias recibida: 8
  • ar
Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) managed by the SQL Server Memory Manager for an instance of SQL Server.

In Object Explorer, right-click a server and select Properties.
Click the Memory node.
Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.
You can also do it in T-SQL using the following commands (example):

exec sp_configure 'max server memory', 1024
reconfigure

Perdon me dio vagancia traducirlo pero se entiende bastante bien


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
3 Replies
1347 Views
Last post May 01, 2017, 03:53:32 PM
by Cacikus
42 Replies
13223 Views
Last post June 22, 2023, 06:27:43 PM
by josejose
10 Replies
2944 Views
Last post December 26, 2017, 09:17:06 AM
by -Rastaa.TSM☢
0 Replies
649 Views
Last post May 25, 2019, 01:39:16 PM
by darwinv91
0 Replies
176 Views
Last post June 19, 2023, 01:23:46 AM
by oxey.mu