Trending on TikTok

Buldak

Sunscreen

Sanrio

English

{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}

View Cart & Check Out

Nickname

Let us know how to properly address you.

Update Your Name

xxxxxxx@yamibuy.com

Account Orders Favorites

Points 0

Coupons 0

Gift Card Balance $0.00

Sign Out

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

We will notify you by email when the item back in stock.

Your email: {{remindEmail}}

Cancel

Jingdong book

Microsoft SQL Server企业级平台管理实践

View Cart & Check Out

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Books Computers & Internet Database

Jingdong book

Microsoft SQL Server企业级平台管理实践

Name: Microsoft SQL Server企业级平台管理实践
Brand: Jingdong book
SKU: 3118011141
Price: 49.38 USD
Availability: OutOfStock

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}

Ends in

{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}

{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}

Sale ends in

Sale will starts after Sale ends in

{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details

Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.

Sold Out

Details

Full product details

Editer Recommend

厚积薄发，微软数据库支持部经理分享十年工作经验
鞭辟入里，深入分析全球企业级SQL Server用户典型案例

Content Description

本书是微软全球技术支持中心数据库支持部技术主管的沥血之作，书中案例选自微软全球客户遇到的实际问题。本书的最大特点是面向实战，主要面向Microsoft SQL Server各个版本的数据库系统管理和开发人员，介绍SQL Server关系型数据库引擎在日常使用和开发过程中经常会遇到的问题、其表现形式、背后运行机理、基本理论知识、搜集和分析问题日志的方法，以及解决实际问题的可选手段。
阅读本书可以帮助数据库管理与开发人员更深入地理解SQL Server的原理和运行规律，以提高解决问题的能力。

Author Description

徐海蔚，于2000加入微软亚太区全球技术支持中心企业支持及开发部，数据库支持组。在过去的10年里，一直从事SQL Server的高端技术支持，曾先后担任支持工程师、技术主管和部门经理。服务的客户包括亚太区的大型企业、微软合作伙伴和开发人员。接触的企业级客户遍布大中华地区、新加坡、马来西亚、澳大利亚、新西兰、印度等地。处理SQL Server企业应用实施、日常管理中常见的棘手问题，经验丰富。

Catalogue

第1章数据库空间管理
1.1 文件的分配方式及文件空间检查方法
1.2 数据文件空间使用与管理
1.3 日志文件不停增长
1.4 文件自动增长和自动收缩
1.5 小结
第2章数据库备份与恢复
2.1 备份概述
2.2 选择备份策略和恢复模式
2.3 选择数据库还原方案
2.4 应对由于备份损坏导致的还原错误
2.5 系统数据库备份与恢复
2.6 实例：将数据库系统在一台新服务器上恢复
第3章 SQL Server服务或数据库不可访问
3.1 SQL Server服务启动顺序
3.2 数据库状态切换及Recovery
3.3 系统数据库不能启动的常见原因和解决方法
3.4 用户数据库常见问题和解决方法
3.5 实例：修复Recovery失败的数据库
第4章数据库损坏修复
4.1 常见错误解读
4.2 DBCC CHECKDB
4.3 数据库反复损坏问题应对
第5章连接与认证
5.1 协议的选择与别名
5.2 连接失败检测步骤——命名管道
5.3 连接失败检测步骤——TCP/IP
5.4 一般性网络错误（General Network Error）
5.5 认证与代理问题
第6章 SQL Server内存分配理念和常见内存问题
6.1 从操作系统层面看SQL Server内存分配
6.2 SQL Server内部独特的内存管理模式
6.3 SQL Server内存使用状况分析方法
6.4 数据页缓冲区压力分析
6.5 Stolen Memory缓存压力分析
6.6 Multi-page缓存区压力分析
6.7 常见内存错误与解决办法
6.8 小结
第7章 SQL Server IO问题
7.1 SQL Server的I/O操作
7.2 系统级I/O问题判断
7.3 数据库引擎错误833
7.4 IO问题的SQL Server内部分析
7.5 硬盘压力测试
7.6 小结
第8章任务调度与CPU问题
8.1 SQL Server独特的任务调度算法(SQLOS)
8.2 SQL CPU %问题
8.3 OLTP和Data Warehouse系统差别及常用性能阀值
8.4 小结
第9章阻塞与死锁——知识准备
9.1 锁产生的背景
9.2 锁资源模式和兼容性
9.3 事务隔离级别与锁的申请和释放
9.4 如何监视锁的申请、持有和释放
9.5 锁的数量和数据库调优的关系
9.6 结论
9.7 数据库引擎中基于行版本控制的隔离级别
第10章阻塞与死锁——问题定位与解决
10.1 阻塞问题定位方法及实例演示
10.2 常见阻塞原因与解决方法
10.3 案例分析：连接池（Connection Pooling）与阻塞
10.4 死锁问题定位及解决方法
第11章从等待状态判断系统资源瓶颈
11.1 LCK_xx类型
11.2 PAGEIOLATCH_x 与WRITELOG
11.3 PAGELATCH_x
11.4 Tempdb上的PAGELATCH
11.5 其他资源等待
11.6 最后一道瓶颈：许多任务处于Runnable状态
11.7 小结
第12章语句调优——知识准备
12.1 索引与统计信息
12.2 编译与重编译
12.3 读懂执行计划
12.4 读懂语句运行统计信息
第13章语句调优-问题定位与解决方法
13.1 是否是因为做了物理IO而导致的性能不佳
13.2 是否是因为编译时间长而导致性能不佳
13.3 判断执行计划是否合适
13.4 Parameter Sniffing
13.5 调整数据库设计来优化语句性能
13.6 调整语句设计提高性能
第14章常用SQL Server系统信息与搜集方法
14.1 Windows 事件日志（Event Log）
14.2 SQL Server Errorlog文件
14.3 性能监视器（Performance Monitor）
14.4 SQL Trace文件
14.5 系统管理视图跟踪
14.6 自动化信息收集：SQLDiag工具
14.7 系统自动监视工具 - Performance Dashboard

Specifications

Brand

Jingdong book

Brand Origin

China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use

Scan to Share

Add to favorites

{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}

Clip coupons

Quantity

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Sold by JD@CHINA

Ship to

Free shipping over 69

Genuine guarantee

View details

Region

Added to Cart

Keep Shopping

More to Consider

Coupons

Clip Clipped Over

Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Fulfilled by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Yami-China FC

Service Guarantee

Cross-store Free Shipping over $69

30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69

Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)

Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

Download the Yami App

Feedback

Back Top

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review

{{i}} star

{{i}} stars

{{ parseInt(commentRatingList[i]) }}%

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Load more reviews

Review

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}