SQL Server Performance Forum – Threads Archive
Tuning SQL server 2005 enterprise
Dear Experts/Gurus,I have a problem where my SAP B1 database is very slow in performance. The database is stored in SQL server 2005A and there are more than 10 store outlets connecting to database everyday to perform sales transaction. Sometimes the outlet PC is hang and really slowly, it could take 2-3 minutes to add the sales order.
Do I have to do tuning SQL server 2005A to increase its performance ? If yes,
could you provide me with links relates to the tuning process ? I appreciate your answer. TIA
Rgds,
Hi Johnson, their are some points I can think, they are: 1. The bandwidth is enough capable
2. If it is physically dispersed location what is mean to connect your sap database; vpn/internet
3. Is your users complaining timeouts
4. Run profiler trace to see if any blocking occurred
5. If it is upgraded to new server(new h/w or version),have you update statistics
6. have you check if their is long running transaction that is eating up your CPU/Memory
Regards Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
Tks a lot for your quick reply. Actually the company uses citrix and ICA to make the connection. Perhaps, the causes are the outlets located widespread outside the HQ building. The PC specification in the outlets seems below standard. I will try to check your points here. Rgds,
If you say the outlet PC is hanging then see whether relevant or similar levels of service packs are installed to match up the server, also check under event viewer to see why it hangs.
There are few blog posts over herehttp://sqlserver-qa.net/blogs/perftune/archive/tags/performance/default.aspx to attain performance. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Tks for the link. I will try to browse it and gain the stuffs could be the means to solve the problem.
As I am a new bie in the SQL server, I think i will take time to learn it.
Rgds,
Yes, there is no quick fix like it unless you find the culprit process for that performance loss. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>