Need a SQLDBA to help solve a issue with our SAP app
• We are having locks when we run a program called Data Transfer WorkBench. The Wait types that we are getting are: LCK_M_U, LCK_M_S, LCK_M_RS_U,LCK_M_IS. What means this locks? And, Can we avoid this or reduce the time of the lock? Because this lock to all users in SAP B1, until the Data transfer finish.
• We are getting some locks that one process is blocking itself, the wait types are: CXPACKET, ASYNC_NETWORK_IO. Why Happens this?
• How can we do the maintenance of the databases? for example LDF file. Can be automatic with a job?
• Can you do a tuning of the configurations in the database server for improve the performance of the service? For example the CTFP param isn’t tuned, it is the standard and this could affect the CXPACKET lock.
I attached a file with the screenshots of sql with the locks.
14 freelance font une offre moyenne de $191 pour ce travail
Hi there..... Warm Greetings We came along with your request for SQL DBA help and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals wor Plus
I have 7 years experience in sap B1 sdk addons development,integration and sap crystal reporting. I can show you my previous work if you are interested. thanks
Hi, I have plenty experience in SAP B1 and all it features and tools like DTW. Please let me know further details in order to help you out. Bueno, luego de leer el documento veo que escriben en español, lo que es Plus
I am good at performance tuning.I have solved many locking issues. Please hire me. My skype RajasekharBolla
Doing well on this project Relevant Skills and Experience SQL DBA, logshipping, mirroring, replication, performance tunning,always on and clustering, Having 5 yrsof experience
Hello, I spent over 7 years at Microsoft as a Escalation Engineer for SQL Server. My specialty was performance. On the surface, this looks like a pure query tuning issue (CXPACKET waits are often indicative of this Plus
I have 6 years of expertise in SQL Server migration and data warehousing as well and will be a good fit for the job.
Hello. Have an 8 years experience in T-SQL Development and database administration on Microsoft SQL Server 2000/2005/2012. Stored procedures design. Queries and indexes optimization. SQL Server maintaining - back Plus
A dynamic, result-oriented professional with more than 10 Years of experience in Database Management System and Project Execution. Possess a sound understanding of various technological concepts. A project planner with Plus
Hi, I have 5+ Years of experience manage SQL server database in production environment win different Versions and Editions ( SQL server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016). I have a good expertise in solving Plus