Viewing 15 posts - 1,051 through 1,065 (of 1,179 total)
Hello CrazyMan,
Do not crazy about SPID 1,2,3...
I mean do not worry about 1 to 50 SPID it's exclusively used by internal system. You should worry about 51 onwards SPID.
Good Day!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 13, 2008 at 5:17 am
I am agreed with Gail.
It looks like performance issue. Try to find more detail finding in the errorlog.
Also perform test to find out any hardware & software bottlenack. BE CAREFUL...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 13, 2008 at 5:12 am
I guess Method 1 should be fine.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 13, 2008 at 4:50 am
You can shut down SQL Server 2005 failover cluster. Already your instance is running on the other server. When you will restart server it will work.
Depends: Why you need...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 13, 2008 at 3:34 am
Try to find more detail in event viewr which will hep you to narrow down the issue. Also restart the box or uninstall and reinstall the .net framework. Do not...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 13, 2008 at 2:50 am
You can see the log by using following command:
SELECT * FROM msdb.dbo.sysmail_event_log
See the mail has been delivered by SQL Database Mail on time? Probably you can take it from here.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 4, 2008 at 4:40 am
Another reasons to grow your Tlog is if your Mirroring is not working properly(i.e. latency is more) or if Mirroring is pending on destination DB it won't truncate the log.
Check...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 20, 2008 at 1:59 am
Hello Shree,
Though your db backup size is 6 GB it is quite possible that after restore it will grow upto 27 GB.
Find following things:
1. Check source db data and log...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 17, 2008 at 7:32 am
YOu can think about following third party tool or similar tool:
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 17, 2008 at 7:22 am
Do users are having any blocking problem?
You can use sp_lock to check the lock info.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 17, 2008 at 7:19 am
Hello,
This is very wide questions.
All depend on the how application is as well as the size of the database?
What kind of query generally user will use read or write...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 17, 2008 at 6:37 am
Hi Jackal,
have a look at following gif file it's exchange-cluster but similar way we can have sql cluster.
http://www.progent.com/images/exchange-cluster-1.gif
Also following link will help you to understand more:
http://www.eggheadcafe.com/forumarchives/SQLServerserver/Aug2005/post23633739.asp
http://sql-server-performance.com/Community/forums/t/17436.aspx
Hope this will help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 16, 2008 at 7:19 am
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 14, 2008 at 7:00 am
2) If I have 350 columns in a table, how can I index each n every column?
If performance is not a problem and by hook or crook you would like...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 8, 2008 at 6:31 am
You should not worry about the Data. DBCC Shrinkfile never deletes any data.
It will shrink datafile to specific size which you have mention during the DBCC Shrinkfile command.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 8, 2008 at 4:09 am
Viewing 15 posts - 1,051 through 1,065 (of 1,179 total)
