SQL Server Architecture


This page has moved here

https://sqldbasupport.wordpress.com/2011/06/23/sql-server-architecture-overview/

Advertisements

7 Responses

  1. I found Generic Architecture overview image on the blog.I need its detail explanation of each component .Kindly email the details or links ASAP.
    Thanks

    • Hi there,

      I would definitely provide the related content,
      Anyhow, If you would just spend some time on rest of the content of this article you should understand even more.

      Regards

      Amit Vaid

  2. We have a server running SQL. We are noticing that SQL SERVER.EXE Process is using over 4 GB OF Physical memory.This is causing the server to underperform. The server has 6 GB Memory.Rebooting the server helps . Plz. share your valuable experience with me.

    We are using SQL SERVER 2005, SP 3 WITH MICROSOFT OPERATING SYSTEM 2003 SERVER.

    Regards

    Sushil

    • Hey Sushil,

      You do not need to stop sql server, if its production box,

      I would suggest please reduce the amount of memory you have allocation to sql server instance using sp_configure with reconfigure command in query analyser, this would surely release the enough memory to operating system. The sql server doesn’t automatically de-provision the memory it consumes from total allowed memory.

      Later you may try using awe option to setup memory dynamically.

      Thanks with regards

      amit

    • Sorry for responding late on this…..

  3. Hi Sushil,

    SQL Server will use max or the available memory in the box. It is a memory intensive process but if the OS need for more then it will take it from the SQL Server. you can make SQL Server memory to static instead of dynamic by setting the MAX and min server memory cap. What edition is the SQL Server and is this a32 bit server?

  4. I think this is one of the such a lot vital info for me.
    And i’m satisfied studying your article. Butt wanna statement onn some basic issues, The web site styke iis ideal, the
    articles is in reality nice : D. Excellent process, cheers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: