How to find out free space in LOG .?

Question

Post reply

How to find out free space in LOG .?

Joy Smith San

SSC-Insane

Points: 24877
More actions
June 28, 2009 at 11:26 pm

#205871

Dear All,
One person asked me the following questions in an interview. Pls help.
1. Suppose I have 2 servers. Firt one is with 2GB RAM and the second one is with 8 GB RAM.
Both are having 32bit OS & SQL Server 2005.
If my manager is asking me to enable AWE, which server should I use for database.?
One with 2 GB RAM or 8 GB RAM..? and why..?
2.How to find out free space in LOG .?
Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

joeroshan SSChampion Points: 10377 More actions · Answer 1

1) Awe is for memory greater than 2GB

2) dbcc sqlperf('Logspace')

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

Thanks for quick reply.

Any idea on my first question..?

joeroshan SSChampion Points: 10377 More actions · Answer 3

You can configure SQL server to use more than 2 GB (limit for 32 bit systems), by configuring AWE. So if you are enabling AWE its in the server with 8 GB.

----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe

Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Eswin SSCrazy Eights Points: 8320 More actions · Answer 4

San (6/28/2009)
Dear All,
One person asked me the following questions in an interview. Pls help.
1. Suppose I have 2 servers. Firt one is with 2GB RAM and the second one is with 8 GB RAM.
Both are having 32bit OS & SQL Server 2005.
If my manager is asking me to enable AWE, which server should I use for database.?
One with 2 GB RAM or 8 GB RAM..? and why..?

The one with 8GB ram.

For more on AWE (Advanced Windowing Extensions) :

http://stupidprogrammer.com/2008/09/24/sql-server-2005-and-awe/[/url]

2.How to find out free space in LOG .?

DBCC sqlperf(logspace)

Tanx 😀

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 5

Thanks,

I answered like that. Wanted to confirm.

Once again thanks.