SQL执行中占CPU资源最多的前10条查询

select top 20 total_worker_time/execution_count as avg_cpu_cost,plan_handle,execution_count,(select substring(text,statement_start_offset/2+1,(case when statement_end_offset=-1then len(convert(nvarchar(max),text))*2else statement_end_offsetend - statement_start_offset)/2)from sys.dm_exec_sql_text(sql_handle)) as query_textfrom sys.dm_exec_query_statsorder by [avg_cpu_cost] desc
找出工作负荷中运行最频繁的查询select top 10 total_worker_time,plan_handle,execution_count,   (select substring(text,statement_start_offset /2 +1,       (case when statement_end_offset = -1          then len(convert(nvarchar(max),text))*2          else statement_end_offset        end - statement_start_offset)/2)      from sys.dm_exec_sql_text(sql_handle)) as query_text   from sys.dm_exec_query_stats   order by execution_count desc
找到被编译得最多的前10位查询计划select top 10 plan_generation_num,execution_count,  (select substring(text,statement_start_offset /2 +1,     (case when statement_end_offset = -1       then len(convert(nvarchar(max),text))*2       else statement_end_offset      end - statement_start_offset)/2)    from sys.dm_exec_sql_text(sql_handle)) as query_textfrom sys.dm_exec_query_statswhere plan_generation_num>1order by plan_generation_num desc
来源:https://blog.csdn.net/easyboot/article/details/7623746

信息通信发展司召开IPv6规模部署及专项督查工作 全国电视电话会议

2018年8月3日,工业和信息化部信息通信发展司召开IPv6规模部署及专项督查工作全国电视电话会议。部信息通信发展司司长闻库,部网络安全管理局副局长张新,部信息通信管理局互联网处处长裴玮,中国信息通信研究副院长王志勤出席会议并讲话,中央网信办信息化发展局处长方新平受邀出席会议。会议由部信息通信发展司巡视员陈家春主持。

会议指出,发展基于IPv6的下一代互联网,不仅是互联网演进升级的必然趋势,更是助力互联网与实体经济深度融合、支撑经济高质量发展的迫切需要,对于提升国家网络空间综合竞争力、加快网络强国建设具有重要意义。

会议要求,以“通盘布局、移动先行、流量突破”为主要工作思路,推进各项改造工作。其中,基础电信企业30个自营APP是LTE IPv6“高速公路上的测试车”,各企业要力争提前完成改造,真正实现端到端贯通,为提升用户规模与网络流量打下良好基础;内容分发网络(CDN)改造要适度超前,为互联网应用改造提供足够的内容加速资源;云服务企业,特别是大型云服务企业不仅要及时完成云产品IPv6改造目标,还要充分发挥平台优势,面向中小型企业提供IPv6技术咨询和网站改造等服务;终端制造企业要进一步加快移动和固定终端的软硬件升级,消除IPv6盲点。各企业间加强沟通协调对接,合力破解具体困难问题;各通信管理局、各企业、中国信息通信研究院要按照相关要求,扎实做好专项督查各项工作,确保相关工作取得实效。

工业和信息化部机关司局、北京市通信管理局、基础电信企业、北京邮电大学、部属单位及部分互联网企业有关部门负责人在现场参会。各省(区、市)通信管理局、基础电信企业及互联网企业负责人在视频分会场参会。

来源:http://www.miit.gov.cn/n1146290/n1146402/n1146440/c6291799/content.html

Whistleblower reveals Google’s plans for censored search in China

传谷歌搜索将接受审查重新进入中国

Illustration by Alex Castro / The Verge

Google is reportedly planning to relaunch its search engine in China, complete with censored results to meet the demands of the Chinese government. The company originally shut down its Chinese search engine in 2010, citing government attempts to “limit free speech on the web.” But according to a report from The Interceptthe US tech giant now wants to return to the world’s biggest single market for internet users.

According to internal documents provided to The Intercept by a whistleblower, Google has been developing a censored version of its search engine under the codename “Dragonfly” since the beginning of 2017. The search engine is being built as an Android mobile app and will reportedly “blacklist sensitive queries” and filter out all websites blocked by China’s web censors (including Wikipedia and BBC News). The censorship will extend to Google’s image search, spell check, and suggested search features.

The web is heavily censored in China, with the country’s so-called Great Firewall stopping citizens from accessing many sites. Information on topics like religion, police brutality, freedom of speech, and democracy are heavily filtered, while specific search topics (like the 1989 Tiananmen Square protests and Taiwanese independence) are censored completely. Advocacy groups report that censorship in the country has increased under President Xi Jinping, extending beyond the web to social media and chat apps.

The whistleblower who spoke to The Intercept said they did so because they were “against large companies and governments collaborating in the oppression of their people.” They also suggested that “what is done in China will become a template for many other nations.”

Patrick Poon, a researcher with Amnesty International, agreed with this assessment. Poon told The Intercept that if Google launches a censored version of its search engine in China it will “set a terrible precedent” for other companies. “The biggest search engine in the world obeying the censorship in China is a victory for the Chinese government — it sends a signal that nobody will bother to challenge the censorship any more,” said Poon.

In a statement given to The Verge, a spokesperson said: “We provide a number of mobile apps in China, such as Google Translate and Files Go, help Chinese developers, and have made significant investments in Chinese companies like JD.com. But we don’t comment on speculation about future plans.”

According to The Intercept, Google faces a number of substantial barriers before it can launch its new search app in China, including approval from officials in Beijing and “confidence within Google” that the app will be better than its main rival in China, Baidu.

Google previously offered a censored version of its search engine in China between 2006 and 2010, before pulling out of the country after facing criticism in the US. (Politicians said the company was acting as a “functionary of the Chinese government.”) In recent months, though, the company has been attempting to reintegrate itself into the Chinese commercial market. It launched an AI research lab in Beijing last December, a mobile file management app in January, and an AI-powered doodle game just last month.

Although this suggests Google is eager to get a slice of China’s huge market of some 750 million web users, ambitions to relaunch its search engine may yet go nowhere. Reports in past years of plans to bring the Google Play mobile store to China, for example, have so far come to nothing, and Google regularly plans out projects it ultimately rejects.

Notably, relations between China and the US have worsened in recent weeks due to trade tariffs imposed by President Trump. The Intercept reports that despite this Google staff have been told to be ready to launch the app at short notice. The company’s search engine chief, Ben Gomes, reportedly told employees last month that they must be prepared in case “suddenly the world changes or [President Trump] decides his new best friend is Xi Jinping.”

来源:https://www.theverge.com/2018/8/1/17638480/google-china-search-engine-censored-report