Home Events Live Blog – SQL Server Sri Lanka User Group Meetup – May...

Live Blog – SQL Server Sri Lanka User Group Meetup – May 2014

4306

More information here.

From Press From Press May 21, 20148:14 pm

With that note, we conclude this event tonight. Good night everyone. Thanks for tuning in.

From Press From Press May 21, 20148:14 pm

Prithvi now asks some questions and gives away goodies.

From Press From Press May 21, 20148:11 pm

Prithvi will take questions now. He is done with his presentation.

From Press From Press May 21, 20148:05 pm

Physical IO extension to Resource Governor. Azure integration and backup encryption are some other features. – Prithvi

From Press From Press May 21, 20148:01 pm

Generally, long operations get locked due to activities. You can’t skip to the next task instead. – Prithvi

From Press From Press May 21, 20147:57 pm

Incremental updates reduces windows. They are dropped and created. – Prithvi

From Press From Press May 21, 20147:55 pm

Buffer pool= memory for Data. This feature allows data pages temporary park in SSD. – Prithvi

From Press From Press May 21, 20147:50 pm

One great limitation in Columnstore indexes is removed making it a presentable edition. – Prithvi

From Press From Press May 21, 20147:49 pm

Currently, some of the features are limited since it just got released recently. – Prithvi

From Press From Press May 21, 20147:41 pm

No clustered index, foreign keys and triggers are allowed either. – Prithvi

From Press From Press May 21, 20147:40 pm

We have a few new Data Types in SQL Server 2014. CLRs are discontinued. – Prithvi

From Press From Press May 21, 20147:38 pm

2 values can crate the same # value. Create # values so that your search is narrowed. – Pritvi

From Press From Press May 21, 20147:32 pm

Benefits of MOT : No fragmentation and no locks/latches. – Prithvi

From Press From Press May 21, 20147:31 pm

Prithvi now talks about Memory-optimized tables. This definitely impacts on performance.

From Press From Press May 21, 20147:29 pm

Even Dinesh Priyannkara did a session about the same topic few meetups ago. So Prithvi will be quick.

From Press From Press May 21, 20147:28 pm

Prithvi will not be talking about every new feature of SQL Server 2014, since it will take much more time for him.

From Press From Press May 21, 20147:25 pm

Prithvi will discusses new features in SQL Server 2014, and review them.

From Press From Press May 21, 20147:23 pm

Second speaker for days would be Prithiviraj Kulasingham, MVP, Principal Database Administrator (Pearson Lanka).

From Press From Press May 21, 20147:17 pm

Video by them.

From Press From Press May 21, 20147:15 pm

Today we have a special event partner. GUNNAR EYE WEARS. They will demo their product and video.

From Press From Press May 21, 20147:14 pm

We are back.

From Press From Press May 21, 20147:02 pm

Before we move on to the second speaker, we will be having a small refreshments break.

BRB

From Press From Press May 21, 20146:56 pm

Bathige will now asks questions and will give away goodies.

From Press From Press May 21, 20146:55 pm

Susantha concludes his session and no questions are asked from him.

From Press From Press May 21, 20146:54 pm

How to remove execution plans? Clear the cache and buffer pool. – Bathige

From Press From Press May 21, 20146:51 pm

Query stats: gives you aggregated info about the queries executed against the DB. – Bathige

From Press From Press May 21, 20146:51 pm

Query # are used to identify similar queries. – Bathige

From Press From Press May 21, 20146:47 pm

You can pass the SQL handle in to hexadecimal. – Bathige

From Press From Press May 21, 20146:44 pm

Tip: You can consider creating one parameterized statement or consider using plan guides. – Bathige

From Press From Press May 21, 20146:41 pm

If single-use plans are >50%, it is recommended to enable ‘optimeze for ad-hoc workload’ option. – Bathige

From Press From Press May 21, 20146:39 pm

Even though Plan handle can be different, functionally plans could be similar. – Bathige

From Press From Press May 21, 20146:36 pm

Bathige now is going to Clear the cache of a DB/table with a query. Which he says is dangerous method.

From Press From Press May 21, 20146:33 pm

You can filter out operations by filtering with index scan. – Bathige

From Press From Press May 21, 20146:32 pm

Similarly you can check for implicit check warnings. Which could be having key lookups. – Bathige

From Press From Press May 21, 20146:30 pm

Plan data is stored internally as XML. If you can manipulate these structured xml values, you can retrieve many data. – Bathige

From Press From Press May 21, 20146:27 pm

Bathige now talks about Useful queries which can help you to find single use-plans. He will be demo-ing later on.

From Press From Press May 21, 20146:25 pm

The Plan Cache is an important aspect of SQL Server memory which stores execution plans for various SQL Server objects. This session will introduce you to the Plan Cache, and provide you tips on maximizing re-use of cached plans, troubleshooting plan cache related issues, eliminating unnecessary recompilation and minimizing plan cache pollution.

From Press From Press May 21, 20146:24 pm

First of all we have Susantha Bathige, who is from Pearson Lanka and will be talking on What you should know about the SQL Server Plan Cache

From Press From Press May 21, 20146:23 pm

This is Team Digit Live from Microsoft SL Office for SQL May Meetup.

From Press From Press May 21, 20146:22 pm

Hey.

Comments

comments

NO COMMENTS

Leave a Reply