Ahmedabad SQL Server User Group is committed to helping the SQL Server community through a number of activities and events for the IT community in Ahmedabad....

Sir, This phrase is use in the sql health check spreadsheet. It is very comprehensive. You can find it at www.bradmcgehee.com. I hope now you get it. Waiting... Snehal...

Hon. Brad McGehee....

Sir, That is what i am asking you. What is mean by OLTP/OLAP ratio? Can we replace read/write ratio with OLTP/OLAP ratio? Pl refer only first paragraph of my previous reply and i think you would get it. Do not consider second one as it is my...

Yes Sir, you may be right there. I think you can understand this way, let me try out. Suppose you r a DBA and you know your workload is hybrid(OLTP + OLAP). If someone ask you "What is your OLTP/OLAP workload ratio ?" . What would be your answer? H...

Hi Sir, As we know the terms OLTP AND OLAP used to describe the workload. While tuning of DB it important to have ratio of OLTP/OLAP, if we have hybrid workload to implement effective indexing. So, how can i find OLTP/OLAP ratio? Any help would be he...

Hi Sir, As we know the terms OLTP AND OLAP used to describe the workload. While tuning of DB it important to have ratio of OLTP/OLAP, if we have hybrid workload to implement effective indexing. So, how can i find OLTP/OLAP ratio? Any help would be...