just read some technical document about sql server perfomance tuning from SQL Server MCM,
in this documentation brento describe quick summary sql performance tuning using perfmon with awesome tips and trick, great screenshot and sample and very easy to understand.
this is very recommended reading.
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
cheers
there are several resources free learning from microsoft learning that can help to enhance our sql skills and knowledge..
http://learning.microsoft.com/Manager/BrowseResults.aspx?browseval=pt&pid=199%2523218%2523221&cid=221&nav=productandtechnology:Products+and+Technologies/Server+Technologies/Microsoft+SQL+Server/Microsoft+SQL+Server+2008&nav=trainingtype:E-Learning/&srtfld=uscurrencyvalue&srttype=descending&qry=&navclicked=1
beberapa topic yang menarik antara lain
SQL Server 2008: Database Infrastructure and Scalability
This clinic covers the following topics.
Availability, Security, Scalability, and Resource Management and Troubleshooting Enhancements
Policy-Based Management and Multi-Server Administration
Performance Data Collection
Management Implications of New Features
SQL Server 2008 :Upgrade and Application Compatibility -
This clinic covers the following topics.
SQL Server 2008 Upgrade Technical Value Proposition
Anatomy of an Upgrade
Upgrade Advisor
Application Compatibility Testing
Planning Your Upgrade
Belakangan ini sering sharing" dengan teman yang baru beli gadget andoid baru, setelah di oprek" dan coba install aplikasi dari market nya.. ternyata banyak aplikasi" yang menarik (at least for me it interesting) hehehe...
but, recently I am interest with
Google Googles
if usually we use query or find with keyword
select *
from <obj.name>
where <field.name> like '%%'
but with this application we can find with visual object instead of using words
even we can use this application for playing play chess,( you can see the video for more information)
hehehe...
gara" aplikasi ini jadi tertarik mengetahui lebih dalam tentang OODB dan CBR
Environment for the project
development and operation maintenance is mixed.
today i has read a good article, it about Top 5 DBA tasks that are a waste of time (and might be hurting your SQL Server) in topic database management and administration.
Some tasks performed by DBAs on a regular basis not only have little to no benefit to SQL Server, but can actually be detrimental to the health of their environments.
#1. Shrinking the database
Daily shrinking of the database is bad for a few reasons. From the technical side, the biggest impact you will see is a greatly increased index fragmentation after each database shrink. In addition, shrinking the database files increases both the physical file fragmentation on the disk subsystem and the I/O load on the server, which decreases performance for other functions while the shrink operation is running.
#2. Truncating the transaction log
#3. Restoring a full backup to the log shipping target
#4. Defragging then rebuilding your indexes
#5. Manually reading through error logs
original article from
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1376199,00.html?mboxConv=searchCIO_RegActivate_Submit&after read this article, it seems many things to do in my office,in my sqlserveragent everyday always running jobs for "dump and shrink for all database".
Hiks.. today antri untuk dapatkan win 7 77ribu di PIM II sudah antri dari jam4an..
tapi waktu jam6an, antrian nya tiba berubah.. yg tadinya masuk urutan 77 besar, berubah jadi 100besar..
hiks... :((
berawal ketika tadi genset kantor rusak, dan akhirnya harus menshutdown semua server yang ada..
dan proses maintenance genset sekitar 2 jm, dan setelah genset berfungsi kembali,sewaktu ingin meng up kan server kembali, tiba2 server hp proliant seri ML, yang baru dipakai kurang dr 1 thn, dngn OS win server 2003 Enterprise.Edition sp 2, tiba2 menjadi booting terus, di layar hanya ada gambar loading windows server 2003 dengan bar yang terus berjalan. [:'(]
akhirnya diupayakan berbagai cara oleh bagian infrastruktur, safemode, last know good configuration, tetap tidak membuahkan hasil..
hingga dengan berat hati, server yang baru berjalan kurang dari 1 thn harus di install ulang.. [:'(]
hiks..agak sedih juga seh, masa win server 2003 bisa semudah itu corrupt, pdhal servernya tidak pernah mati mendadak.
kl menurut bagian infrastruktur nya seh penyebabnya kemungkinan OS nya corrupt..
hingga akhirnya install ulang, OS, setting2 ulang sql server nya, dan replication nya.. [:'(]
dan total butuh waktu kurang lebih 3jam.
hiks..menyesal sekali, banyak belajar dari my first disaster ini, (learn from the scratch) menganggap tidak akan pernah terjadi hal seperti ini,biasanya hanya planing yg
standart saja, spt raid, backup sql, file.
- harus ada disaster recovery plan
- tiap replikasi sebaiknya ada backup sql script nya
- hrs belajar lebih banyak tentang win server jg, saat ini bacanya tentang sql server terus.hahahaha...
next time must better and always learn from scratch.
kejadian bermula saat gak masuk kantor karena sakit..
Ya akhirnya drpd gak jelas di kosan, berfikir untuk rapihin notebook, rencana yang sudah lama sekali tertunda.heheheh..
akhirnya backup semua data, dan mulai untuk install win7.
lalu akhirnya setelah selesai semua, rasanya seperti ada yang kurang, ternyata saya belum install browser firefox, dan setelah dicari di komp, ternyata mentahannya tidak ada..
tanpa pikir panjang, saya download saja dari website nya toh..
setelah mau download, di page home (http://www.mozilla.com/en-US/firefox/ie.html)
nya ada yang sedikit menggelitik.
Using Internet Explorer
is So 2006
You deserve a better browser: Firefox is safer, faster
and easier to use than IE. Make the switch today!
![]()
hehehe... persaingan web browser kian memanas.
well.. this is my first post on my blog..
my name is mathias arya aditya
i am fresh graduate from binus university, bachelor degree majoring information system, devotee database.
actually i join to geeks.netindonesia since march.
i will focus with Database technology..
about Data Modelling, Database Design, TSQL, Business Inteligent, Data Warehouse and data mining..
i am very interest with Database Technology..
if any friends like same interest with me, we can share each, and of course i very happy if any friends can give insert for me..
thats all..
best regards.
[tias]