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.

Skills: Database Administration, Database Programming, Microsoft SQL Server, SQL

See more: 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

About the Employer:
( 0 reviews ) Ukraine

Project ID: #17324855

14 freelancers are bidding on average $191 for this job

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 More

$180 USD in 3 days
(11 Reviews)
5.2
$55 USD in 1 day
(55 Reviews)
5.2
$144 USD in 3 days
(4 Reviews)
3.6
$155 USD in 1 day
(5 Reviews)
3.6
$111 USD in 1 day
(9 Reviews)
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

$555 USD in 10 days
(1 Review)
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 More

$277 USD in 3 days
(2 Reviews)
2.7
rajasekharreddyb

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

$155 USD in 3 days
(3 Reviews)
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

$133 USD in 3 days
(0 Reviews)
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 More

$222 USD in 1 day
(0 Reviews)
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.

$155 USD in 2 days
(0 Reviews)
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 More

$150 USD in 3 days
(0 Reviews)
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 More

$155 USD in 3 days
(0 Reviews)
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 More

$222 USD in 3 days
(0 Reviews)
0.0