Where should I check?

No I don't have other files restricted

LOGFILe is set to restricted and databases size is 134210.00 MB and available 1192.73 MB

Is it could be a case that my SQL Server is running out of available process memory. How can I check how much memory is allocated to the SQL Server?...

I want to know if

my SQL Server is not running out of available process memory. Probably we hit that memory which is allocated to the SQL Server.

How can...

This is not me,someone did it, but database is not small is is 130,209 GB, how can I identify biggest tabels? Do I need to re start agent to refresh...

So I will change

1.FileGrowth in Megabytes from 500 to 1024 primary

(2.FileGrowth in Megabytes from 100 to 500 filegroup=datafile2

3.FileGrowth in Megabytes from 100 to 500 (enable autogroth is checked)filegroup=docs

4.FileGrowth in...

What is the autogrowth set to? In other words, how many MB or how many percent?

I have 5 data types

1.FileGrowth in Megabytes 500 (enable autogroth is checked)filegroup=primary

2.FileGrowth in Megabytes 100...

What it is?

1Create disk space (I have space on the drive 200GB free)

2.setting autogrowth, all of my files,except Log set to autogrowth

3.dropping objects,I don't know which objects needs to be dropped

--------------------------------------------------------------------------------

sql monitor:

Deadlock encountered .... Printing deadlock information

Wait-for graph

Node:1

KEY: 7:72057606206259200 (4d17e82b2d6c) CleanCnt:3 Mode:X Flags: 0x0

Grant List 3:

Owner:0x00000002654A4A80 Mode: X Flg:0x0 Ref:0 Life:02000001 SPID:101 ECID:0 XactLockInfo: 0x0000000350E923A8

SPID: 101 ECID: 0 Statement...

I don't know how to run deadlock graph,but from red gate here is my results:

spid:101 dbid: 7, object id: 72057606206259200, index id: (4d17e82b2d6c) UPDATE Line #: 727

Language Event:...

Hi, my tempdb got big to 3 GB, so how can I check what is causing tempdb to grow so fast?

Thank you

From sql logs:

Sourcespid89

Message

A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED...

Thank you,

So for system database:

Backup, check database integrity (master,model,msdb),rebuild indexes(msdb) is this correct?