Log in | Register

Veerendra Thati, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Veerendra Thati, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



Veerendra Thati

About Veerendra Thati

This author has not yet filled in any details.
So far Veerendra Thati has created 5 entries.

Read-Write Concurrency in SQL Server Analysis Services

Hello Friends and Geeks,

I write this blog when the tallest Ganesh of Hyderabad is on the way for Immersion.

Coming to the topic for this post

Most of us know, how read/write concurrency and locking works with SQL Server Database Engine.

Ever wondered what would be the locking pattern for Processing and Querying concurrency for SQL Server Analysis Services (SSAS)

The […]

By |September 15th, 2016|Categories: SQL Server||0 Comments

Index Usage Analysis on databases with AlwaysON Secondary Readable Replica

Hi Friends and Geeks,

I write this blog at a time when traffic in Hyderabad has come to a stand-still owing to incessant rains since morning today.

Coming to the topic of this blog-post, we know how important it is to identify unused indexes and rarely used non clustered indexes to reduce the IO foot print of […]

By |August 31st, 2016|Categories: SQL Server||0 Comments

How to resolve High Compilations/Second problem in SQL Server

Hi Friends and Geeks!

Sharing an experience on resolution of High Compilations/Second performance counter in SQL Server from one of my consulting assignments.

The threshold for Compilations/Second is mentioned as 10% of Batch Requests/Second by various MVPs and in our case it was around 40 to 50%

Investigation Process

Investigate for queries with same query_hash but multiple plan_handles using […]

Easiest way to install additional packages in SQL Server R Services

Beginners coming to SQL Server R Services would find it a bit difficult to understand the integration of R and SQL Server. Bob Ward has provided a great insight into the SQL Server R Services Architecture in the recently concluded #SSGAS2016 summit.

When I started exploring this feature, the first bottleneck I faced was the installation […]

By |August 16th, 2016|Categories: SQL Server||0 Comments

Incremental Cube processing of AdventureWorks Cube in SSAS

Hello Friends!

SSAS Cubes are increasingly becoming bigger and bigger and thus processing the cube using “Process Full” option is not feasible in all scenarios.

Considering the importance of Incremental Cube Processing, I wanted to extend the AdventureWorks sample cube to include Incremental Cube Processing

However I could not find much material on this topic on the […]