TheSQLGuru (2/4/2015)

---

Until you mentioned it I had never heard of Zabbix. That isn't a good sign for you BTW, as I have been dealing with SQL Server for ~20...

I use the following code to monitor our Alwayson group.

SELECT ar.replica_server_name,

DB_NAME(dbr.database_id) AS [DBName] ,

dbr.database_state_desc,

dbr.synchronization_state_desc,

dbr.synchronization_health_desc,

...

first, you should find the query, and confirm with your client, then kill them.

I often find the most longest query first, and check if there is any optimization I can...

My build is SQL SERVER 2012 SP2(10.0.5058.0) and there are 128 GB or 256GB on my servers, the "TokenAndPermUserStore" used more than 17 GB memory, we meet the non-yield...

Bru Medishetty (2/17/2010)

---

This may help.. I am not 100 % sure

On the Server, when opening the SSMS, right click and choose Run as Administrator

Also check with your System Admin to...

Try to use report 'Disk usage by top table' to find which table use so big space, and then analysis this table.

USE [master]

GO

--Change DB recovery mode

ALTER DATABASE [DATABASENAME] SET RECOVERY SIMPLE WITH NO_WAIT

GO

USE [DATABASENAME]

GO

-- Shrink DB LOG

DBCC SHRINKFILE (N'DATABASELOGFILENAME' , 0, TRUNCATEONLY)

GO

USE [master]

GO

--Change recover mode back

ALTER DATABASE [DATABASENAME] SET RECOVERY FULL...

Maybe you can try to use a virtual machine to run the three database, and use another vm to run the others database, and allot appropriate memory to each VM

Dave Ballantyne (12/29/2009)

---

Are you passing search arguments as parameters ?

If so you should be able to duplicate the poor performance using variables.

In any case you will need to post the...

I haven't meet that large database, maybe you...

How to register?