To test the performance of a stored procedure we run the stored procedure several time.
You have observed when you run the stored procedure first time it took time but when you run next time it is faster. It just because the stored procedure /data is cached.
Now , due to this cache problem we got a wrong assumption that the stored procedure is fast but in actual it it taking cache data.
To assure that when we run the stored procedure it will run on new set of data not from buffer data SQL Server provided a option which is called “DROPCLEANBUFFER”
You can run this command as shown in below fig
Either way you can restart SQL Server services also .
It is one of the effective command by which we can evaluate of stored procedure performance.
As discussed in last post VNext launched. Now I downloaded VNext to test how to use it.
Let’s understand it step by step
Now when you will try to open new project window. You will find 4 new project template with name VNext as shown below in fig
I tried ASP.NET vNext Web Application.
Now I found a new structure of Web application and surprised that in next project there is no web.Config file instead on it I found 3 different files
Now lets understand these files one by one
1) Config.json :- Config.json by the name it is clear that it will keep all the configuration detail Like your database connection string and etc will reside in this file. see below config.json’s snap
2) Project.json : Project.json file contents all the reference of the project the best part of it as you add the entries in this file it will automatically reflect your project reference. I personally like this miracle
It is something like your console application where you will provide startup file.This file is same like those feature which will startup all the things
Now let see actual physical project structure. You will find a new file which is Kproj.
The Kproj is new type file. “K” is new feature introduce. New compiler is used.
I will explain more features in next post.
Till than enjoy.
Thanks & Best Regards,
Recently, Microsoft launched a new version of Visual Studio which is VS 2014 (VNext). Although I am not always happy with such a quick versions by Microsoft but this time it will a great NEWS and give a strong competition to all the open source competitors.
VNext is a open source. With VNext you will get MVC 6 , .NET framework 4.5.3.
You can download the VNext from following link
In VNext you will found a lot change. Major highlights
1) Project solution change
2) New configuration file
3) New dependency (reference) utility
5) web.Config removed
7) Next Generation “JIT”
There are many more things which we will discuss later on.
Till Enjoy VNext.
Thanks & Best Regards,