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.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 SQL Server migration issue

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -