GDL

ISBN-13 (pbk): 978-1-4302-1902-6
Book from gdlhub / 2012-06-18 10:30:16
Oleh : Grant Fritchey, Sajal Dam, Apress
Dibuat : 2012-06-18, dengan 1 file

Keyword : SQL Server 2008 Query Performance Tuning Distilled
Subjek : SQL Server 2008 Query Performance Tuning Distilled
Sumber pengambilan dokumen : Internet

Performance is frequently one of the last things on anyone’s minds when they’re developing

a system. Unfortunately, that means it usually becomes the biggest problem after that system

goes to production. You can’t simply rely on getting a phone call that tells you that procedure

X on database Y that runs on server Z is running slow. You have to have a mechanism in

place to find this information for yourself. You also can’t work off the general word slow. Slow

compared to what? Last week? Last month? The way it ran in development? And once you’ve

identified something as running slow, you need to identify why. Does it need an index? Does

it have an index that it isn’t using? Is it the CPU, the disk, the memory, the number of users,

the amount of data? Now you’ve identified what and why, but you have to do something about

it. How? Rewrite the query? Change the 􀁓􀁄􀁁􀁎􀁁 clause? The questions that will come your way

when you start performance tuning are endless.

Beri Komentar ?#(0) | Bookmark

Properti	Nilai Properti
ID Publisher	gdlhub
Organisasi	Apress
Nama Kontak	Herti Yani, S.Kom
Alamat	Jln. Jenderal Sudirman
Kota	Jambi
Daerah	Jambi
Negara	Indonesia
Telepon	0741-35095
Fax	0741-35093
E-mail Administrator	elibrarystikom@gmail.com
E-mail CKO	elibrarystikom@gmail.com