Data Base Shrink

I have SQL Server 2000 on WIN2k Advanced Server And I have
a Database Consists of:-
1-Single Database File .
2-single transaction log file(initial size 2 MB).
I have Observed that the transaction log file'Capacity
reaches 23 Giga Byte so I Made a Backup for the whole
database and then I tried to shrink the log file using
enterprise manager shrink database wizard.then I
discovered that the physical file capacity was not
reduced, although enterprise manager gave me a message
that the file has been shrinked.
I tried More And More But No result.
Help will be so much appreciated
Best Regards:-
Ahmed NourGood shrink article can be found :-
http://www.mssqlserver.com/faq/logs-shrinklog.asp
--
HTH
Ryan Waight, MCDBA, MCSE
"Ahmed Nour" <a_m_nour@.hotmail.com> wrote in message
news:0d7201c393e7$706c2590$a401280a@.phx.gbl...
> I have SQL Server 2000 on WIN2k Advanced Server And I have
> a Database Consists of:-
> 1-Single Database File .
> 2-single transaction log file(initial size 2 MB).
> I have Observed that the transaction log file'Capacity
> reaches 23 Giga Byte so I Made a Backup for the whole
> database and then I tried to shrink the log file using
> enterprise manager shrink database wizard.then I
> discovered that the physical file capacity was not
> reduced, although enterprise manager gave me a message
> that the file has been shrinked.
> I tried More And More But No result.
> Help will be so much appreciated
> Best Regards:-
> Ahmed Nour|||Ahmed ,
Refer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow and AutoShrink
--
- Vishal

CXPACKET and XEON Processors

I have a question that I hope someone can answer. We are
running a WIN2K Server with SQL Server 2K SP 3. It is a
dual xeon processor machine with hyperthreading enabled.
I have noticed that the SQL PERF (Waitstats) CXPACKET is
much higher with xeon processors and was told that WIN2K3
would help with the lock times with the threading. Can
anyone speak to this? I have disabled the hyperthreading
at the BIOS level and noticed a higher level of
performance on the WIN2K machine.
Thanks
GregYou might try reducing 'max degree of parallelism' configuration option
rather than disable hyperthreading. If this is an OLTP system that
doesn't really benefit from parallel queries, try setting it to 1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Greg" <greg@.stockamp.com> wrote in message
news:141001c3822d$d7be2d90$a001280a@.phx.gbl...
> I have a question that I hope someone can answer. We are
> running a WIN2K Server with SQL Server 2K SP 3. It is a
> dual xeon processor machine with hyperthreading enabled.
> I have noticed that the SQL PERF (Waitstats) CXPACKET is
> much higher with xeon processors and was told that WIN2K3
> would help with the lock times with the threading. Can
> anyone speak to this? I have disabled the hyperthreading
> at the BIOS level and noticed a higher level of
> performance on the WIN2K machine.
> Thanks
> Greg|||Waittype on CXPACKET is normal for parallel queries. Do not reduce MAXDOP
because you see waits on CXPACKET, reduce MAXDOP because you've proven it
makes queries you care about go faster.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Greg" <greg@.stockamp.com> wrote in message
news:141001c3822d$d7be2d90$a001280a@.phx.gbl...
> I have a question that I hope someone can answer. We are
> running a WIN2K Server with SQL Server 2K SP 3. It is a
> dual xeon processor machine with hyperthreading enabled.
> I have noticed that the SQL PERF (Waitstats) CXPACKET is
> much higher with xeon processors and was told that WIN2K3
> would help with the lock times with the threading. Can
> anyone speak to this? I have disabled the hyperthreading
> at the BIOS level and noticed a higher level of
> performance on the WIN2K machine.
> Thanks
> Greg