Viewing 15 posts - 47,221 through 47,235 (of 49,552 total)
There are a number of possible causes.
You could be hitting hardware bottlenecks. You could have poor table or index design, you could have poorly written queries. You could have all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 1:58 pm
Probably depends whether the data for the varchar(max) is in the row, or in separate (blob) pages. If the data's out of row then you'll be incurring extra reads for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 12:27 pm
Something else to check. Are either the mdf file or ldf file marked as readonly? (Check the file properties)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 3:58 am
No, because using functions on the column in the where clause means that SQL cannot use an index seek to locate the rows, and it will have to scan.
OR or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 1:55 am
Oh my. That's unexpected and very unfortunate
D&D's still a big part of my life. Got a game this weekend that I'm running.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 1:01 am
Rohit Chitre (3/4/2008)
If I start taking log back up every hour. then will it be advisable to truncate & shrink only the log file.
No. It is never advisable to truncate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2008 at 12:22 am
Set the database into restricted mode. Means that only sysadmn and db_owner can connect to it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 11:49 pm
Do you have a backup of MSDB?
If you recreate the database, you'll loose all your jobs, DTS packages and a few other things. They're all stored in MSDB.
If you don't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 11:46 pm
Varchar also only stores the characters you enter. A varchar(1000) with 15 characters in will take up 17 bytes in the row (15 for the characters, plus 2 to store...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 11:44 pm
Rohit Chitre (3/4/2008)
Thanks everyone for valuable information.I am running following statements to truncate the log and database size
Dump Tran with no_log
DBCC Shrinkdatabse (' ')
Ouch.
The first of those ensures...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 11:31 pm
If the NC was wider, I'd agree with you. As it it, unless Column1 is highly selective, or queries are done that only filter on and retrieve Column1, then it's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 11:22 pm
You say you truncate the log. What exactly do you mean by that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 1:01 am
Good point. It could very well be that.
Set Statistics IO ON and then do your tests. Check the logical and physical IOs. Physical means it reads from disk, logical...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 12:59 am
Index2 is redundant. You should be able to drop it without having an effect
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2008 at 12:41 am
As ALZDBA said, the function will prevent index seeks. Change the query to avoid any function on the columns in the where clause.
Also, the select * makes covering indexes hard....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2008 at 5:07 am
Viewing 15 posts - 47,221 through 47,235 (of 49,552 total)