Viewing 15 posts - 42,826 through 42,840 (of 49,552 total)
It could be anything. That's almost the database equivalent of asking "Why's my car making a strange noise?"
Probably you have some badly performing queries. Run profiler for a while and...
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
November 28, 2008 at 12:24 pm
barb.wendling (11/28/2008)
I have set up a remote server side trace and selected to write data to a table on a development server.
Since a server-side trace can't write to a...
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
November 28, 2008 at 12:21 pm
barb.wendling (11/28/2008)
Can you suggest what event selection items to use? Or which template? I have the trace file going to a mapped drive - not to the server.
I would strongly...
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
November 28, 2008 at 12:15 pm
bhuvnesh.dogra (11/28/2008)
Actually ,,,if i have a database with total size 100gb ,used : 87 gb and free 5 gbthen
i would shrink it upto 80 gb
You can't shrink 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
November 28, 2008 at 12:02 pm
Don't use sp_addlogin. It's deprecated and it doesn't have the new features (like password policies). Use CREATE LOGIN rather. In the create login statement you can specify the SID which...
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
November 28, 2008 at 6:22 am
jordonpilling (11/28/2008)
Had already tried that, made no major difference i'm afraid, i have just tried it again and it had no effect either.
Very odd. So it's not parameter sniffing then...
Can...
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
November 28, 2008 at 6:21 am
bhuvnesh.dogra (11/28/2008)
but is the main issue if i shrink the data file the related log file increase heavily ...and if i then create again indexes...
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
November 28, 2008 at 6:12 am
p.s. Unrelated to the performance problem, but important.
Are you aware that your asp page is highly vulnerable to SQL injection?
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
November 28, 2008 at 5:22 am
Hmmm......
If you run the following, does the performance improve?
sp_recompile 'usp_SummaryOfCashReceiptsByCalMonth'
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
November 28, 2008 at 5:18 am
Will that space be reused? If so, leave it. There's no harm in free space within a database.
If it will never be reused, do a shrink file (or a series...
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
November 28, 2008 at 5:05 am
And the subscriptions only display the latest 500 threads. For me, that's completely useless. It's only three weeks worth at the moment.
Frankly I find searching with google far faster than...
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
November 28, 2008 at 4:55 am
Please don't create new threads for existing problem. All you're doing is wasting people's time as they answer questions that have already been answered elsewhere.
No moer replies to this thread...
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
November 28, 2008 at 4:51 am
The string for the IN needs quotes around all the values
(user1,user2,user3,user4,user5)
Not going to work as those are strings. You're also duplicating the brackets.
Pass the user list as ''user1'',''user2'',''user3'',''user4'',''user5''
Two final words:...
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
November 28, 2008 at 4:50 am
LiteSpeed does have the ability to do object restores from a full backup. I don't recall exactly how, it's been a while since I used the product. I seem to...
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
November 28, 2008 at 4:41 am
Ninja's_RGR'us (11/28/2008)
Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!
My comments was more...
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
November 28, 2008 at 4:35 am
Viewing 15 posts - 42,826 through 42,840 (of 49,552 total)