DEV Community: Biren

integrate Real time Audio video chat application with Company CRM system

Biren — Sat, 23 May 2020 06:45:56 +0000

we trying to integrate Real time Audio video chat application with Company CRM system, Our CTO recommend us to Use wowza media server for same and ask us to explore wowza setting and features, but after week i found wowza is kind of live and VOD of streaming Engine server,

i just want to know what should be use case of media server, on Real time Audio video chat application

i doing SQL tuning in Company databases but i don't know where to start

Biren — Sat, 25 Jan 2020 09:17:24 +0000

i am doing SQL tuning in Company databases but i dont know where to start as i am new in DBA i joined new company where they have lots of databases, and it issue with databases, can anyone help me where to i start what should be step

What is an execution plan?

Biren — Wed, 15 Jan 2020 03:31:16 +0000

Execution plans can tell you how a query will be executed, or how a query was executed. They are, therefore, the DBA’s primary means of troubleshooting a poorly performing query. Rather than guess at why a given query is performing thousands of scans, putting your I/O through the roof, you can use the execution plan to identify the exact piece of SQL code that is causing the problem. For example, it may be scanning an entire table-worth of data when, with the proper index, it could simply backpack out only the rows you need. All this and more is displayed in the execution plan.