Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2013-12-23 : 08:35:53
|
| Hi We migrated one of our sql server to a new server with more RAM space, included more core processors. But we are facing high performance issues in our server.The jobs which used to take few seconds are now taking more than the normal time.What could be the possible check points to identify where the issue is from?Thanks in advance.- Varalakshmi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-23 : 14:21:29
|
| Run PerfMon to see if you have a hardware bottleneck. If the jobs are queries, then run those queries in SSMS and see what performance you get plus check the execution plans and statistics io/time. Probably you'll need to update stats on the tables, but also verify you have auto update stats turned on. You should likely LOWER your server-side MAXDOP setting (sp_configure). My baseline value for OLTP systems is 2, and then I adjust as necessary. You can also adjust it in queries so that it doesn't affect other sessions.Is LPIM set for the SQL Server service account? Any messages in the error log such as slow I/O?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL Server migration issue