cdumont (10/14/2011)

---

Every night when my SQL 2008 R2 does its nightly maintenance task to backup the DB's, it wont release the system memory after it completes.

The Maintenance job...

ALTER DATABASE tempdb MODIFY FILE...

followed by restarting sqlserver is the easiest way.

If your tempdb grew too big, you might consider pre-sizing it big and disabling auto-growth.

ketan_katkar (10/14/2011)

---

Hi,

It's seem to be MS SQL Server's I/O operation performance issue. To imporove you MS SQL I/O performance you need to do as per below.

Kindly restructure your MS SQL...

NaDi (10/14/2011)

---

hi! a little help here please.

i have here 3 tables, the cluster table, field table and a variety table..

here are the conditions:

-1 variety can be planted in many...

battery_acid_h (10/14/2011)

---

If anyone is familiar with Dynamics NAV and the database structure, or even if this is something familiar, please help!

The dynamics NAV databases can have several companies in a...

google says http://support.microsoft.com/kb/290787

Sql server isn't adding that select, your c# code is.

What kinds of waits are you seeing?

http://www.simple-talk.com/sql/performance/investigating-sql-server-2008-wait-events-with-xevents/

What kind of hdd's?(interface, speed, etc)

What is buffer cache hit ratio?

Disk queue length for each drive?

How big are db's?

Workload read or write intensive?

How many transactions/sec?

Any other io errors in event...

Too many vlf's?

Google: 8 steps to better transaction log throughput

You can change it right from ssms. No restart or reboot is required. take the current size of your buffer pool, subtract 200 mb, and try that as...

that query needs to take a very brief exclusive lock on the database (like 1-2 seconds).

if others are currently using the database, your query will block indefinately. check who the...

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/56660bac-4e2e-4a93-b1ef-5bea9728d26d/

have you tried running it in 32 bit mode on the server?

which driver are you trying to use?

sql native client? (sqlncli 9.xxxx)

sql native client 10? (sqlncli10 10.xxxx)

Sql server? (sqlsrv32 6.xxxxx)

the 64 bit install for sql native client installs both...

sqlserver12345 (10/12/2011)

---

24:11.4spid1sAppDomain 65 (SMS_N07.dbo[runtime].68) is marked for unload due to memory pressure.

24:11.4spid1sAppDomain 65 (SMS_N07.dbo[runtime].68) unloaded.

24:14.6spid65AppDomain 66 (SMS_N07.dbo[runtime].69) created.

select single_pages_kb + multi_pages_kb + virtual_memory_committed_kb

from sys.dm_os_memory_clerks where type =...

you need to quote the commands and enclose them in a script block.

powershell "&{ Get-WmiObject -Class Win32_Service -computername SERVERNAME | select @{name='ServerName';expression={$_.__Server}}, Name, DisplayName, StartName, StartMode | Export-Csv c:\temp\monitor\test.csv...