Viewing 15 posts - 1 through 15 (of 17 total)
Hi,
You can capture blocking queries / sql statement and it's related infirmations ( like CPU usage, I/O , read-write memory etc. ) and send it to your email id. Basically...
May 12, 2010 at 4:23 am
It is quite possible and easy task. Basically you need to first decide on what column ( date ) you need to do the partition on your existing table. You...
May 6, 2010 at 5:24 am
I would suggest to go about Trigger optioto send alert or database mail whne order is come to database. This is good to maintane as we have good control over...
May 6, 2010 at 5:13 am
You can do that with Partial database restore operation. Check below link for more information and syntax.
http://msdn.microsoft.com/en-us/library/aa196613(SQL.80).aspx
May 6, 2010 at 5:06 am
It's look like your T-log backup gets completed but entry in the msdb database (Backupset table) is failing. Check if the entries of backup's are going into Backupset table or...
May 6, 2010 at 4:54 am
Hi Stev,
can you just describe how we can test if there is bottelneck in Disk subsysten and CPU utilization is high ?.
It would be great if you can explainthis.
May 14, 2009 at 6:34 am
Please check if your SQL server services are in domain user account. Also if you are login from Manag Studio with windows auth then you should have domain access for...
May 13, 2009 at 5:33 am
Hi ,
Thats all depends upon your transactions and writing speed of transaction log. T- Log write is most improtant factor when you are processing bulk records.
Whats type transactions you are...
May 13, 2009 at 5:28 am
If you want to reduce the logging and make it faster on Delete/Update/Insert statment then i think making smaller batches is good idea.
You can take chunk of desire records and...
May 13, 2009 at 4:29 am
Yes If it is 64 bit then no need to enable AWE option. But for confirmation, please check perfmon- Total Server memory and perfmon- Target Server memory counters.
I think your...
May 13, 2009 at 12:50 am
You will get this option by executing sp_configure.
You can reset the value by override. As per me, if you are running OLTP operation then keep it default i.e. or if...
May 12, 2009 at 6:24 am
Hi Thulsi,
below is the dmv which will gives you total wait time by wait type. If it is indicating CPU bottel neck then you need to look into CPU cause.
Here...
May 12, 2009 at 5:43 am
Is it your dedicated SQL server or shared ? If it is shared then please look into which processes taking more CPU utilization.
If your SQL server it's taking maximum CPU...
May 12, 2009 at 4:38 am
Default value of max working thread is 255. So anything over 255 will slower down the performance.
If your application is OLTP then i would suggest to keep max dop 0...
May 12, 2009 at 4:23 am
Viewing 15 posts - 1 through 15 (of 17 total)