glad to help !
freely ask SQL related questions here
we are here to help you round the clock

Many Thanks

for clearing my doubts about performance threads in SQL server

Thanks john

....Storing data non-contiguously on disk and having many truncation in your database, resulted your database has occur fragmentation.
In other word we can say your database performance is decrease to avoid this you should perform these operations

1.Defragmentation
2. Rebuilding the indexes
3. Reorganising the indexes
4. Shrink Database (If needed)
5. Partition Table/Indexes
6. Reallocate page in logical order by heap method

Pankaj

Great info

So how can be overcome these issues ??

DBA responsible for maintaining SQL server and its database but, as the volume of data has grown and the load on the server increased, the queries have
grown slower and deadlocks have become a frequent occurrence.
so these are some main points that may responsible for performance degradation in SQL Server

1. Retrieving too much data.
2. Misuse of transactions.
3. Misuse of indexes.
4. Mixing OLTP, OLAP, and reporting workloads.
5. Inefficient Index
6. Join operations or inefficient join operations
7. Using an inefficient disk subsystem.

Thanks Pankaj

Can we monitor what is actually causing our SQL server performance how can we limit on that

thanks

john

Hi JohnMat

You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000.
These counters allow you to view or save information about the overall performance of your server.
When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed.
You must have administrative access to your SQL Server to use these objects, SQL Server Admins should find them invaluable in monitoring and tuning the database server.

To open the Performance monitor in Win2K, go to Start | Programs | Administrative Tools | Performance. When viewing your performance data in real time, you can view it as a report, a chart, or a histogram

Attachment 12

Monitoring load on capacity of the SQL server

Hi,

How to monitor the capacity load of an SQL server? Is this possible with native SQL server Management, I am specifically interested in finding out how database is slowing down and causing poor performance of SQL server.

Thanks