Closed

SQL DBA help

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.

Compétences : Administration de Bases de données, Programmation de bases de données, Serveur SQL Microsoft, SQL

en voir plus : automatic backup databases sql 2005, help need graphic designer urgent illustration, sql statements help, sql server 2016 architecture diagram, sql server books, sql server documentation, sql server 2017, microsoft sql server technical support, sql server, msdn sql server download, sql server 2016 documentation pdf, sap, need help need find website customize pictureplease help, need sql dba project, help need job, help need quick simple website, help need work designer illustrator, help need design creative brochure, website kindness mission help need template, help need change face picture

Concernant l'employeur :
( 0 commentaires ) Ukraine

Nº du projet : #17324855

15 freelance font une offre moyenne de $193 pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(55 Commentaires)
5.3
schoudhary1553

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
4.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
3.4
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
3.6
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.6
JaamMuhammadI

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)
2.9
agardiles

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
2.7
rajasekharreddyb

I am good at performance tuning.I have solved many locking issues. Please hire me. My skype RajasekharBolla

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
2.3
Jaganmohanmjmr

Doing well on this project Relevant Skills and Experience SQL DBA, logshipping, mirroring, replication, performance tunning,always on and clustering, Having 5 yrsof experience

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
robertbur

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
pnaveenred

I have 6 years of expertise in SQL Server migration and data warehousing as well and will be a good fit for the job.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
mxmbrzhn

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
adakshuvajit

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
MariosPavlidis

Greetings, Several issues are described in this project and they need to be attended so the performance of the SQL server be optimized. I can make a general health check, describe the findings with full explanatio Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
akella1202

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0