New To DWH Environment

• santoshkal

  SSC-Addicted

  Points: 497

  More actions

  September 23, 2014 at 1:30 am

  #296818

  HI,

  I'm new to DWH environment i'm facing lot of performance issues so check u plz let me know the list to check for the performance on servers

  thanks in advance

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  September 23, 2014 at 1:56 am

  #1747318

  That question is way too broad to be answered in just a few lines.

  First of all you have to set-up monitoring so you know where things go wrong. You have to find the bottlenecks.

  And then you have to remove these bottlenecks one by one.

  A good resource:

  SQL Server 2012 Query Performance Tuning

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP