I see there is a Maximum server memory (in MB) 2147483647, this is really big, what should I change this to?

This is the default memory option

you can just leave...

Ok now I should force my manager for changing the queries.

thanks any way

one last question

If I add more .ndf files to the database will reduce pagelatch_up waits and resource is 5:1:3 no.

Because I found there are three...

Gila and Craig Fareel

Help Me ! Dudes with your knowledge.

Make sure your session because it lets only one connection to the server.

All the best.

set startup option '-m' in configuration manager -->MSSQLSERVER properties.

See here

have you ever come across this problem

If so let me now what you did ?

Is there a way to find out whether we are running too close to the limit on drive space, during heavy processing/system usage?

Select disk space query results into...

But managers are not willing to change the the design now.

When I enabled trace flag 1118 is good for two days and there is no waits at all but...

the DDL is select * into table and then drop table commands

But there are several queries like that

@craig-2

Yes there is scenario where local physical tables were creating and dropping in the user database not in temp db.

There are lot waits with wait types pagelatch_up

and the wait resource...

@Gila

Wait type is pagelatch_up and wait resource is 5:1:3

5 is my database id 1 is the file group and 3 is the page id

when you see...

Just give him db_securityadmin. works fine for that.

Yes exactly its a contention on my datafile SGAM pages

But not in tempdb its on user db.

How I do this in prod.

Dividing into equal no of files and into different...

Obviously it effects the replication instead just take backup online.