Wednesday, July 17, 2013

[SQL Server] SQl 2008 R2 - Maximum memory

[SQL Server] SQl 2008 R2 - Maximum memory

SQl 2008 R2 - Maximum memory

Posted: 16 Jul 2013 06:05 PM PDT

Hi AllI am using sql 2008 R2 DB. As per the msdn document max memory that can be allocated to any istance is 1GB. In sql server property it showing 2147483647 MB which is default setting.The machine on which this server is installed has 4 GB RAM. Will it make any differnce if i increase the sql server max memeory more than 1GB eg 2GB?We have noticed that sometime memeory utilization on the server is more tah 90%. Please advice.Regards

Not your usual documentation question

Posted: 17 Jul 2013 03:31 AM PDT

I am a server/SQL admin in a large organization. We have thousands of SQL databases on many clusters and individual servers supporting many departments. Each major department has their own DBA's who (we hope) document their database structures. The issue we have is not the actual database documentation, but rather the high level "what is out there", "who owns it", "what application connects to it", etc. We do have some documentation that has been compiled over the years, but nothing comprehensive and complete. Us admins have been asking management to get involved in this for years now (apps, servers, SQL, etc.) and nothing went forward so I have taken it as my personal task in what little free time I can scrape up.Before I spend too much time building requirements I wanted to see if there are any tools, templates, scripts, etc. that have been created for this purpose. Commercial or non-commercial is OK. Something that goes beyond just SQL to document servers, applications, etc. would be a huge benefit. Tools that would scan the servers for info would be great because none of us really has time to manually discover and document the basic data. I have been hunting for something like this without much luck.Can anyone make some suggestions?Thanks

Stupid Question: Return Object Explorer to It's original position

Posted: 26 Nov 2010 07:57 AM PST

Stupid question but I accidentally moved object explorer from it's original default position on SSMS. By default, object explorer is to the left, and query window is to the right. Now object explorer seems to have been "undocked" and query window occupies the screen from left to right, such that if I open a new query it opens "behind" object explorer. How do I restore the original "default" view in SSMS?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog