Questions with SQL Server 2005

[sendba]

All,

We have installed SQL Server 2005 on a X64 with 64 Gb RAM.
This server is very slow in response and when we checked the TaskManager it is using only 1 Gb of RAM.

Can someone let me know if they have seen this problem. If so is there any way to rectify this.

Am i missing some parameter settings....

Thanks

Sen

 

[JackVam]

When you say (slow in response) , do you mean queries run against databases? or do you mean some other functions?

All the IT jobs in one place -

http://www.ITjobfeed.com

 

[ptheriault]

Set your min and max server memory options. You can set that through SSMS by right clicking on the server and selecting properties in the object exporer window.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[sendba]

I thought SQL Server 2005 will use the memory automatically but why we need to set the min and max memory.
Whenever I try to open Mangement Studio it hangs for one minute because it is trying to connect to a server which is not available.

Please let me know how to solve this issue.

Sen

 

[mrdenny]

If SSMS is trying to connect to a server which doesn't exist then you need to remove that server from the list of registered servers.

Yes SQL will manage the memory it self, but it needs to be told how much memory it is allowed to manage.

How large are the databases on this server?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mrdenny]

What other services are running on the server?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[sendba]

Its a brand new server with only SQL Server loaded.

 

[mrdenny]

But, what other services are running on the server? SSAS, SSRS, Anti-virus services, Sharepoint, IIS, Exchange, File shares, etc?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog