SQL Server Management Studio Kya Hai?
SQL Server Management Studio (SSMS) ek graphical interface (GUI tool) hai jisse aap SQL Server ke almost saare operations perform kar sakte ho.
SSMS Se Hum Kya-Kya Kar Sakte Hain
SSMS ke through aap bahut saare tasks perform kar sakte ho.
Database Development
- Database create karna
- Tables create karna
- Relationships define karna
- Constraints add karna
Database Administration Tasks
DBA daily SSMS me ye kaam karta hai:
- Database backup
- Restore
- Jobs create karna
- Maintenance plans
- Security manage karna
Query Execution
SSMS me queries run karna sabse common task hai.
Troubleshooting
Agar SQL Server slow ho raha hai ya error aa raha hai to SSMS se aap:
- Activity Monitor check kar sakte ho
- Execution plan analyze kar sakte ho
- Server logs check kar sakte ho
Server Properties Explore Karna
SSMS me aap server ke bahut saare settings explore kar sakte ho.
Right click on server → Properties
Yaha aapko important information milegi:
- SQL Server edition
- Processor count
- Memory configuration
- Server version
Server Memory Configuration
SQL Server ko memory allocate karna bahut important hota hai.
Example:
Max Server Memory set karna.
Example setting:
2048 MB
Background me SQL Server ek stored procedure run karta hai:
EXEC sp_configure 'max server memory', 2048
Ye setting SQL Server ko batati hai ki maximum kitni RAM use kar sakta hai.
Real World DBA Tip
Agar server me 16GB RAM hai to SQL Server ko full memory mat do.
Example best practice:
OS ke liye memory chhodo
SQL Server ke liye remaining allocate karo
Security Settings
SSMS me aap security settings bhi configure kar sakte ho.
Example:
Login auditing.
Options:
- None
- Failed logins
- Successful logins
- Both
Best practice:
Failed login auditing enable karna chahiye
Isse suspicious activity detect hoti hai.
Remote Query Timeout
Default value hoti hai:
600 seconds
Matlab agar remote query 10 minute se zyada chalti hai to SQL Server usse cancel kar dega.
Agar long running queries hain to is value ko increase kiya ja sakta hai.
Backup Compression
Agar database backup ka size bada hai to compression enable kar sakte ho.
Example:
Database size:
300 GB
Without compression:
300 GB backup
Compression ke baad approx:
90 GB – 120 GB
Ye storage cost bahut reduce karta hai.
Default Database Location
SQL Server me data files, log files aur backups alag folders me store kiye ja sakte hain.
Example:
C:\SQLData
C:\SQLLogs
C:\SQLBackups
Agar disk space khatam ho raha hai to new drive add karke default path change kar sakte ho.
Example:
D:\SQLData
Ab jo bhi new database create hoga wo automatically D drive me create hoga.
Parallelism Settings
SQL Server performance tuning me ye setting bahut important hoti hai.
Cost Threshold for Parallelism
Default value:
5
Meaning:
Agar query ka cost 5 se zyada hai to SQL Server parallel execution use karega.