Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLFeatures

Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.

Archives: October 2012

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation DAC…. Check how to use DMO sys.dm_exec_query_stats and sys.dm_io_virtual_file_stats for finding top CPU/Memory/IO queries with scripts… Detect Worst Performing SQL Queries – Part 3

Read more

0 comments, 333 reads

Posted in SQLFeatures on 13 October 2012

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation DAC…. Check how to use DMO sys.dm_exec_query_stats and sys.dm_io_virtual_file_stats for finding top CPU/Memory/IO queries with scripts… Detect Worst Performing SQL Queries – Part 3

Read more

0 comments, 13 reads

Posted in SQLFeatures on 13 October 2012

Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail:Use PowerShell to collect stats…

Read more

0 comments, 11 reads

Posted in SQLFeatures on 5 October 2012

Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail:Use PowerShell to collect stats…

Read more

0 comments, 380 reads

Posted in SQLFeatures on 5 October 2012