These are the ways to measure your SQL Server DBA team project success:

• Project completed on time and within budget
• Satisfy the project owners / stakeholders
• Learn from the project

If your SQL Server DBA team project passes those tests, your SQL Server DBA team did succeed.