Thank very much Pinal for all DBA, all world!, your solutions ever, ever function for me. I want to more problems, because I know that you are with me. ! Bendiciones desde México ¡
Pinal, nice to see your stream. You have been giving great stuff for us and your posts have been solving lot of our SQL issues. Appreciate your efforts!
@24:56 - how does one fix these problem, if they are a problem: 1. LCK_M_IS 2. ASYNC_NETWORK_IO - are there more wait types to look out for? - can you combine your missing index, unused index, and wait stats scripts into one sql script, and allow it to run on any running production database?
VERY VERY EFFECTIVE MATERIAL FOR THOSE WHO WANT TO BRING PERFORMANCE FOR THEIR DATABASES. PLEASE KEEP SHARING YOUR EXPEREINCES WITH US IN A FORM THAT WE CAN LEARN FROM IT... THANK YOU THANK YOU.
Hi Mr. Pinal. Thank you very much sir for this great video. I have watched the recorded version. It was very great and helped me a lot. The way you explain things is really great. Please do not change anything and continue exactly like this. I look forward to your future videos. Thank you.
Great stream sir! I missed the announcement that you were going on a live stream so had to watch the recording. Hopefully I can join the next one live :)
One more feather in your cap. A live stream. Boss hats off. Keep posting such great content and I would be looking forward to see you live the next time 👏🏻👏🏻👍
Thank u sir, for bringing this type of material for us with your experience we learn lot. And found very fun learning of sql with u which enhanced our knowledge of SQL. And keep this live session going we eagerly waiting for ur next video.
Sorry I missed the video earlier, but this is nice of you to do for everyone. A question I had...is there ever a reason to *not* update the compatibility mode of a database to the version that it actually is (outside of deprecated code perhaps)? What sort of problems have you seen from this and is there a way to forecast that a problem could occur that needs to be addressed before the update?
Hi Jonathan, many people do not update the compatibility mode in the fear of the poor performance and many do not do it, just because they do not know the setting exists. I personally like to upgrade to the latest version all the time and iron out performance issues.
I don't know if you can explain it but in a common select, if I write the following in the where: select * from table1 inner join table2 on table1.id = table2.id where table1.date> = '2021-01-01' quickly return the data, but when I do exactly the same query but with parameters. declare @ date smalldatetime = '2021-01-01' select * from table1 inner join table2 on table1.id = table2.id where table1.date> = @ date Results take too long. difference of minutes vs 3 seconds in the first case.
Love your videos. I have been watching your videos for a while and you make these subjects really interesting. You have great energy. Weird. I only have audio in left channel.
Hey Pinnal, I've watched a lot of your videos and read your blog. I appreciate the great work you do. I would like to ask you if you would kindly do a video on DMV that will aid with DBA Routine operations with explanation.
Hello Pinal, I watch almost all of your videos that are amazing, I'm learning many technics with your sixty-second video. Can you please make a video on arithmetic overflow error converting float to data type numeric while processing cube? How do I find the value that is throwing an error?
Hi Pinal Deva, I started learning MSSQL and got a task from my boss saying how to reduce the CPU utilization? My Findings: I have collected the top 3 queries causing high CPU and one of them is creating procedure, in that procedure they were using multiple "Insert Into" statements so I suggested them to run the query in batch-wise - is this the right approach? Could you please help me with your knowledge on this
Yes, running queries in batches can help reduce CPU utilization. Additionally, consider these tips: Ensure appropriate indexes. Rewrite queries for efficiency. Update statistics regularly. Monitor performance using SQL Server tools.
@@PinalDaveSQLAuthority Thanks Pinal..can you provide me the link to your video where I can learn how to read the execution plan and how to improve the performance of SQL queries. :)
Been a while, but isn't there a lazy index update configuration option that allows the index to update after the completion of the query instead of updating before completion? How well does that work here?
@@PinalDaveSQLAuthority I believe I was thinking async statistics under the db options, would have sworn there was one for indexes too...also curious about delayed durability's effect on performance and real world dangers
I was unable to attend the live stream and thank you for having this recorded so useful for many people like us. Much appreciated!
Glad it was helpful!
Thank very much Pinal for all DBA, all world!, your solutions ever, ever function for me. I want to more problems, because I know that you are with me. ! Bendiciones desde México ¡
Very kind of you.
Congratulations on your first live!
Thanks
Pinal, nice to see your stream. You have been giving great stuff for us and your posts have been solving lot of our SQL issues. Appreciate your efforts!
Very motivating.
@24:56 - how does one fix these problem, if they are a problem:
1. LCK_M_IS
2. ASYNC_NETWORK_IO
- are there more wait types to look out for?
- can you combine your missing index, unused index, and wait stats scripts into one sql script, and allow it to run on any running production database?
Here is the answer to all the questions - blog.sqlauthority.com/2021/03/08/sql-server-wait-stats-collection-scripts-updated-march-2021/
This was great. Please keep them coming.
Thank you so much
VERY VERY EFFECTIVE MATERIAL FOR THOSE WHO WANT TO BRING PERFORMANCE FOR THEIR DATABASES.
PLEASE KEEP SHARING YOUR EXPEREINCES WITH US IN A FORM THAT WE CAN LEARN FROM IT...
THANK YOU THANK YOU.
Thanks so much for motivation.
Hi Mr. Pinal. Thank you very much sir for this great video. I have watched the recorded version. It was very great and helped me a lot. The way you explain things is really great. Please do not change anything and continue exactly like this. I look forward to your future videos. Thank you.
Glad it was helpful!
Talking straight to the problem- solution scenario is always fun. 👍 Great video ! And definitely would like to see more on the subject. 😀
Thank you so much!
Great video Pinal! Please, update us with more similar content.
Will for sure do.
Great stream sir! I missed the announcement that you were going on a live stream so had to watch the recording. Hopefully I can join the next one live :)
I hope so too! Good to receive your comment my friend.
One more feather in your cap. A live stream. Boss hats off. Keep posting such great content and I would be looking forward to see you live the next time 👏🏻👏🏻👍
You motivate me...you encourage me...you are my source of energy. 🙏
It was very interesting and hope to see more stuff
Absolutely 🙏
Your all sessions are very useful thanks a lot.
You are most welcome
Good presentation! I missed the announcement but I am glad I was able to watch and learn!
Thank you for kind words.
Thank u sir, for bringing this type of material for us with your experience we learn lot. And found very fun learning of sql with u which enhanced our knowledge of SQL. And keep this live session going we eagerly waiting for ur next video.
You are very kind
Thanks Pinal - you are the best. Awesome!
Very kind of you
Sorry I missed the video earlier, but this is nice of you to do for everyone. A question I had...is there ever a reason to *not* update the compatibility mode of a database to the version that it actually is (outside of deprecated code perhaps)? What sort of problems have you seen from this and is there a way to forecast that a problem could occur that needs to be addressed before the update?
Hi Jonathan, many people do not update the compatibility mode in the fear of the poor performance and many do not do it, just because they do not know the setting exists.
I personally like to upgrade to the latest version all the time and iron out performance issues.
Hello Pinal,
It was a nice session and more informative.
Thanks
Glad you enjoyed it!
Thanks it is really useful information. Also thank you for shearing all your experience with us.
Thank you for encouragement
I don't know if you can explain it but in a common select, if I write the following in the where:
select * from table1
inner join table2 on table1.id = table2.id
where table1.date> = '2021-01-01'
quickly return the data,
but when I do exactly the same query but with parameters.
declare @ date smalldatetime = '2021-01-01'
select * from table1
inner join table2 on table1.id = table2.id
where table1.date> = @ date
Results take too long.
difference of minutes vs 3 seconds in the first case.
You are suffering from Parameter Sniffing issue.
Love this video :)
- please put some of the links in the video description
Thanks
Love your videos. I have been watching your videos for a while and you make these subjects really interesting. You have great energy. Weird. I only have audio in left channel.
Thank you. After 7 min audio is in both ears.
Thanks for sharing your experience.
My pleasure!
Sorry, I was unable to attend the live stream, but Next one will sure attend, was busy in work, thanks for Email invite Pinal
Next time!
Hey Pinnal, I've watched a lot of your videos and read your blog. I appreciate the great work you do. I would like to ask you if you would kindly do a video on DMV that will aid with DBA Routine operations with explanation.
Noted
Sir, always we should use tempdb and dbname.table.name.colname while writing queries in stored procedure for performance improvement?
Sure
Great video! Awesome content!
Thanks so much!
why did you not show the STATISTICS for IO & TIME for each query ???
That we covered in next live.
thank you, Pinal
Do more like this
Sure
Hello Pinal, I watch almost all of your videos that are amazing, I'm learning many technics with your sixty-second video.
Can you please make a video on arithmetic overflow error converting float to data type numeric while processing cube?
How do I find the value that is throwing an error?
Great topic.
Very useful video, please continue more parts
Thanks so much
Very useful . Please continue
Thank you, I will
Hi Pinal Deva,
I started learning MSSQL and got a task from my boss saying how to reduce the CPU utilization?
My Findings: I have collected the top 3 queries causing high CPU and one of them is creating procedure, in that procedure they were using multiple "Insert Into" statements so I suggested them to run the query in batch-wise - is this the right approach?
Could you please help me with your knowledge on this
Yes, running queries in batches can help reduce CPU utilization. Additionally, consider these tips:
Ensure appropriate indexes.
Rewrite queries for efficiency.
Update statistics regularly.
Monitor performance using SQL Server tools.
How can I conclude that bulk inserts are involved in the query?
Pls do more sessions for azure sql db paas where we are not having control on config settings.
Ok
Hello Pinal, this is a very helpful video..can you please tell me about the criteria for choosing which index is required on the table.
Noted. I will create more video on it.
@@PinalDaveSQLAuthority Thanks Pinal..can you provide me the link to your video where I can learn how to read the execution plan and how to improve the performance of SQL queries.
:)
Hi Pinal,
I have watched recorded video, thank you for useful information.
Could you please let us know your second live timings ?
Sure I will
Really informatics !!
Glad you think so!
Hey Sir, You are good going please record more content on performance tuning.
Thank you for kind words.
Very Nice Session sir . its really helpful.
I really wish I could answer this one easily as this one is bit more complex to resolve and need to look at your system in more detail.
Super. I need Q & A session.
👍
Please do more live analysis, it will helpful, Thanks👍
Sure thing!
Been a while, but isn't there a lazy index update configuration option that allows the index to update after the completion of the query instead of updating before completion? How well does that work here?
There is one called index online rebuild.
@@PinalDaveSQLAuthority I believe I was thinking async statistics under the db options, would have sworn there was one for indexes too...also curious about delayed durability's effect on performance and real world dangers
@@jbj1836 Currently there is no such option JBJ, I really loved your question.
How to optimize the stored procedure without knowing logic of stored procedure.
This is a long conversation
the audio was fine the first time, but became worst when you adjusted it :(
Oh...next time there will not be any issues
i have also hearing from left
I made mistake during recording.
you are awesome
Thanks!
I thought my right earbud is not working 😂😂😂
Ha!
Good evening sir
Same to you