Hortonworks

Technical Article

RE: High usage of memory

  • Reply

That is the nature of SQL Server, It allocates as much as it needs.You can limit max memory SQL Server can use by configuring the min and max memory from either EM or sp_configure command.Use performance monitor to watch how SQL Server consumes memory and other system resources. 

You rated this post out of 5. Change rating

2004-08-20

Technical Article

XP_sendmail and mapi profile

  • Topic

Hi EverybodyI hope there is somebody out there who can help me.  I am trying to setup notification on MS SQL Server 2000-8.00.760 (Intel x86).  Enterprise Edition on Windows NT5.0 (Build 2195:Serice PAck 4).I have setup a mail profile using Internet mail server (POP3/SMTP).  The client on the SQL server is Outlook 2000.  Our e-mail […]

You rated this post out of 5. Change rating

2004-08-13

44 reads

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers